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

sudhir0538 — Thu, 18 Jul 2019 06:01:24 GMT

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.

Here 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..

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

lockematthewp — Thu, 18 Jul 2019 17:23:17 GMT

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

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

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

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