Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Qliksense:
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.
May be the sorting is done differently? Have you checked that?
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)
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.
Thanks!