Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rishimessi19
Contributor II
Contributor II

Issue with Filter sorting

Hi

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.

1 Solution

Accepted Solutions
sinanozdemir
Specialist III
Specialist III

Hi,

The below is a hackish way of doing it:

Use Dual() function to give "1" to "J".

Capture.PNG

And then sort as text.

Capture.PNG

I am sure there is a much better way of doing this.

View solution in original post

2 Replies
el_aprendiz111
Specialist
Specialist

Hello,

from the script:

ORDER.png

sinanozdemir
Specialist III
Specialist III

Hi,

The below is a hackish way of doing it:

Use Dual() function to give "1" to "J".

Capture.PNG

And then sort as text.

Capture.PNG

I am sure there is a much better way of doing this.

View solution in original post