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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Rushi21
Contributor II
Contributor II

Sorting Week& year values in filter pane

I have created a filter pane for the week&Year field which i created at the backend. I want them to be sorted in front end first by year and then with respect to the Week no.

example:-

W1-2023

w2-2023

W1-2022

W2-2022 and so on.

Screenshot 2023-07-10 175014.png

Labels (1)
1 Reply
Or
MVP
MVP

I would recommend using Weekname(Date) to create your weeks, rather than string-based concatenation. If you do want to use string based, you can either flip the order so it's e.g. 2022-W38, or you can create a custom sort order along the lines of Right(Week,4) & Week to force the year up front.