Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
sannidhikumar
Creator
Creator

sorting months

Hi All,

how to sort Year and month in order Ex: jun-2017,may-2017.

Capture.JPG

thanks ,

18 Replies
prma7799
Master III
Master III

In Sort > choose dimension > in Expression > put MonthNumber as Descending..

Or please share some sample output.  

sannidhikumar
Creator
Creator
Author

PM ,

i tried but its not getting .

any other idea.

thanks

qlikview979
Specialist
Specialist

Hi,

if you want like below

write the condition  in sort tab and take Descending .

=match(Monthname,'jun-2017','may-2017','Mar-2017','Feb-2017',Dec-2016','Nov-2016','Oct-2016','Sep-2016')


Regards

sannidhikumar
Creator
Creator
Author

mahesh ,

still i am getting same .Capture.JPG

prma7799
Master III
Master III

Share some sample app. Or share your expression and Dimensions  which you using for this chart.

prma7799
Master III
Master III

Or sort by MonthName is Sorting ...

qlikview979
Specialist
Specialist

Please share the sample app

sannidhikumar
Creator
Creator
Author

mahesh ,

due to security reasons i cant share the app .

thanks

Anil_Babu_Samineni

Would you check whether sory by Y-Value is enabled or not? Please confirm me or share image for that

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)