Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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.