sorting months

[sannidhikumar]

Hi All,

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

thanks ,

[prma7799]

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

Or please share some sample output.  

[sannidhikumar]

PM ,

i tried but its not getting .

any other idea.

thanks

[qlikview979]

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]

mahesh ,

still i am getting same .

[prma7799]

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

[prma7799]

Or sort by MonthName is Sorting ...

[qlikview979]

Please share the sample app

[sannidhikumar]

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