Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sudhir0538
Creator
Creator

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
Creator II
Creator II

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