Discussion Board for collaboration related to QlikView App Development.
I have a filter with the following values:
I would like the filter to be sorted so that 'J' is in first value and the rest are sorted in A->Z alphabetical order. As shown below:
I did write an expression in sort tab, but somehow the order is getting reshuffled whenever there is a selection. Note: I did deselect "auto ascending"
Please provide a solution.
The below is a hackish way of doing it:
Use Dual() function to give "1" to "J".
And then sort as text.
I am sure there is a much better way of doing this.
View solution in original post
from the script: