topic Re: Issue with Filter sorting in QlikView

Issue with Filter sorting

rishimessi19 — Thu, 22 Sep 2016 19:41:00 GMT

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.

Re: Issue with Filter sorting

el_aprendiz111 — Thu, 22 Sep 2016 20:22:08 GMT

Hello,

from the script:

Re: Issue with Filter sorting

sinanozdemir — Thu, 22 Sep 2016 20:59:11 GMT

Hi,

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.