Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Sorting changes when selection is made

H All,

I have a list of months, that serves the user as a filter to slice define the report,

the field is sorted by an ascending numerical represntation of the month name, e.g. 012015, 022015, etc. (**details on sorting below)

a.png

When the user makes a choice and marks a specific month, the sorting order is changed to show the selected month on the top,

can i make it static? I believe it's confuzing the user!


b.png

** I attached 2 screenshots: a sample of the sorted simension & it's definition in Sort tab

Thanks in advance,

Nir

1 Solution

Accepted Solutions
Highlighted
Master III
Master III

Re: Sorting changes when selection is made

may be this

in sort tab -> expression    

MinString({1} monthfield)

View solution in original post

5 Replies
Highlighted
Master III
Master III

Re: Sorting changes when selection is made

may be this

in sort tab -> expression    

MinString({1} monthfield)

View solution in original post

Highlighted
MVP
MVP

Re: Sorting changes when selection is made

Write sort expression like:  =Only({1} [Billing Month Num])

Highlighted
Specialist
Specialist

Re: Sorting changes when selection is made

try,

Sort--> Load Order -> Ascending

deselect rest check boxes.

Highlighted
Not applicable

Re: Sorting changes when selection is made

i was looking for the same answer in another post , your answered helped me

thanks

Highlighted
Creator
Creator

Re: Sorting changes when selection is made

Both options works well

Thanks pro's