Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ilanbaruch
Specialist
Specialist

months filter sorting

hi all

 

in QS Filter pane Months field can be sorted ascending or descending by its numeric value.

but how can the current month can be set to the first value in the list ?

 

any ideas ?

 

advanced thanks

1 Reply
Or
MVP
MVP

Custom sort by formula, e.g.:

if(MonthName(Month)=MonthName(Today()),1,Month)

It's probably better and cleaner to make a Is_Current_Month flag in the script, and then custom sort by the flag (0 = yes, 1, no) and secondary sort by numeric value.

If you don't like the idea of custom sorting, you could also load your months pre-sorted in the script (using the sane type of condition), and then uncheck all of the sorting options to make QS sort by load order.