Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
vinayk1
Contributor
Contributor

Sorting months in following 2 charts- my year starts from April and ends in march, how can i sort please help

qlik month sort.png

Labels (5)
2 Replies
Rams-
Creator
Creator

You have to use sorting option by Month as shown below

Rams_1-1680589609853.png

 

 

RafaelBarrios
Partner - Specialist
Partner - Specialist

hi @vinayk1 
first, you need to sure that your month names field is a date field and not text
you can check by using a filter object and see how the values align, aligned to the left means text and to the right number or date

RafaelBarrios_0-1680593863050.png

if that's the case, you'll just have to set the field to sort

RafaelBarrios_1-1680593996380.png

now if your month field corresponds to text, you can try to use another field to sort your months, like the date field

RafaelBarrios_3-1680594210097.png

** check how my months filter its alinged to the left now now, that means text

 

Hope this helps.

Best,

help users find answers! Don't forget to mark a solution that worked for you & to smash the like button😁