How to sort Month-Year date filed in trend chart in Qliksense?
I have a requirement like show the rolling count for last 12 Months.
here i have date field CreateDate, 'YYYY/MM/DD' format
and i have created date Filed like
Month(CreateDate)&'-'& Date(CreateDate,'YY') as Month_Year,
for last 12 months i ahve created on flg like
if(CreateDate <= MonthStart(Today(0),-12),1,0) as Last12M_Flag,
That is my script , logic for getting last 12 month data
here my Dimension is Month_Year but here it is not sorting properly, it is displaying Dec-19 first value, May-19, Mar-19,Jun-19, Oct-19, Nov-19, Sept-19 so it is displaying in this way and data is also rolling in this way but this is not correct
Please guide me here how can i calculate last 12 months cumulative count in scripting side.