Area for people to learn more about current Qlik related job postings.
I have a column Fiscal Mo/Yr and I wanted to sort it in ascending order.
O/P should be like
I am assuming you are talking about doing this in a chart where Fiscal Mo/Yr is a dimension? Try to replace your dimension like this
Date#([Fiscal Mo/Yr], 'M-YYYY')
and then sort numerically...
Alternatively, you can do this in the script
Date#([Fiscal Mo/Yr], 'M-YYYY') as [Fiscal Mo/Yr]
and then use [Fiscal Mo/Yr] as dimension and sort numerically.