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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sort order in bar chart

Hi,

I am trying to sort my bar chart using the expression :  right([FiscalYear],'2') & Num([FiscalMonth],'00')

It works correctly in my qlikview apps. However, it is not working in qliksense. Please help.

Dimension:  ='FY' & right(FiscalYear,'2') & ' MN' & [FiscalMonth]

Qlikview:

qlikview.png

Qliksense:

qliksense.png

1 Solution

Accepted Solutions
terezagr
Partner - Creator III
Partner - Creator III

Have you tried to move 2 to be the 1st dimension based on which you will sort? You just need to drag the dimension 2 in your Sorting menu in Qlik Sense.

View solution in original post

4 Replies
sunny_talwar

May be the sorting is done differently? Have you checked that?

Anonymous
Not applicable
Author

qlikview.png

This is what I am doing. In qlikview I just sort in by expression and mention ascending(starts from 2013) or descendin(starts from 2016)

terezagr
Partner - Creator III
Partner - Creator III

Have you tried to move 2 to be the 1st dimension based on which you will sort? You just need to drag the dimension 2 in your Sorting menu in Qlik Sense.

Anonymous
Not applicable
Author

Thanks!