Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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!