Is there a way to sort a value table?
I have a QS App which loads a bunch of values but I need a default value so I concatenate it to those values.
Regardless what value that default value hast (e.g. "00 Keine Angabe" or " Keine Angabe") it's always listed last in my value table. All other values seem to be ordered by Name, but my value is listed last.
When I first load the default value into Qlik and then concatenate the other rows to it, it's always listed first.
Although this sound like a solution it's really an awkward behavoir and it would be nice to have an order by possibility in MD to decide how the ordering should be.
side note: I only do this "default value" thingy, because I want to give the user a dropdown liste as parameter to a report, but I cannot pick nothing. The parameter in question is optional though. Yes I could do another parameter "use that other parameter: yes/no" but this is really ugly also considering, that I have like 8 parameter for this report and I need a better solution than adding more.
If there's a good solution to that problem please let me know.
ATB Pawel