Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
SatyaPaleti
Contributor III

How to sort month in an order when displaying last 12 months of data in Qliksense Bar Chart

Hi Friends,

Could some one help me on this.  We have a requirement to show last 12 months of Price Data and I can able to get last 12 months of data by using following Expression

sum({1<[Fiscal Date]={'>=$(=MonthStart(Max([Fiscal Date]),-12))<=$(=MonthEnd(Max([Fiscal Date])))'}>}Price)

and Dimension as Month. Following output is generating

last_12_months.PNG

But when ever we select any particular month we can able to see last 12 months data but it's not in an sorted order. We are getting following result

last_12_months_issue.PNG

We need it see in an order. If we select Nov-2019 then it should follow a sequence like Nov-2019, Oct-2019, Sep-2019..... Dec-2018, Nov-2018.

Could some one can please help to create sample qvf  to resolve this issue.  you can find sample data in attachments

Thanks and Regards,

Satya

 

 

 

 

2 Replies
Partner
Partner

Re: How to sort month in an order when displaying last 12 months of data in Qliksense Bar Chart

Check the graph's sorting tab in edit mode, you should have date in the first position and ordered.

Highlighted
SatyaPaleti
Contributor III

Re: How to sort month in an order when displaying last 12 months of data in Qliksense Bar Chart

Hi Saryk,

Thank you so  much for responding on the post.

I am using Max(Date) in Graph Sort option and it's working fine until we doesn't made any selections but  when we making any selections then sorting order is missing. It not displaying an sorted order

Thanks and Regards,

Satya