Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
sudhir0538
Contributor

Display last 12 months data in Bar Chart using dimension not Expression

Hi Pro's,

In my data set data available month wise and year wise. Requirement is like displaying the total delay month wise for last 12 months only based on dimension(i.e Month year field) but not with expression using set analysis.

Kindly help to achieve this. 

Community_1.JPGHere in this chart months dec,nov and oct are belongs to 2018 and remaining are of 2019.

Final output will be display like dimensions order(only last 12 months data)

oct 2018

nov 2018

dec 2018

then 

Jan2019

feb 2019

and so on..

1 Reply
lockematthewp
Contributor II

Re: Display last 12 months data in Bar Chart using dimension not Expression

I believe you would just need to sort by year ascending and then by month ascending.