Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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
Highlighted
Specialist III
Specialist III

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.