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]
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.
Retrieving data ...