Discussion board where members can get started with Qlik Sense.
I am using Month(Date)&'-'&Year(Date) expression in my dimension in bar chart and i want it to be sorted Month and then year wise, Ex-
Jan-13, Feb-13.. and so on.
I see that the expression has been sorted properly but for some reason Oct-2013 and Nov-2013 is getting displayed at the end after Sep-2017.
Please help me get this fixed.
Go to Solution.
Try Sort by Expression Date(Monthstart(Date),'MMM-YYYY')
Thanks ! Makes sense, but did not work.
why don't use
instead of Month(Date)&'-'&Year(Date) ?
MonthName() is Dual Function.
Just give a try by using Date(Monthstart(Date),'MMM-YYYY') as Dim and sorting check Numeric ascending/descending
Thanks All for ur response!
Massimo, your suggestion worked. Thank you !