topic Re: last 12 months bar data in QlikView

last 12 months bar data

tenyeapen — Wed, 25 Nov 2020 16:16:04 GMT

HI All

I need to display last 12 months data on a bar chart. my date field is Created_date and below is my expression I'm using.

sum(if(Policy_Type = 'D' and round((Inception_to_Approval_TAT))<=30,1,0))/(count(if(Policy_Type = 'D', (Inception_to_Approval_TAT))))*100

Please help.

Re: last 12 months bar data

jonathandienst — Thu, 09 Jan 2020 13:04:42 GMT

>>Please help.

How can we help?

Re: last 12 months bar data

tenyeapen — Sun, 12 Jan 2020 04:15:35 GMT

with the above details need to create a rolling 12 month bar chart. Please help me in that.

Re: last 12 months bar data

jonathandienst — Mon, 13 Jan 2020 06:59:52 GMT

There are many blog postings and discussions on how to implement rolling 12 month metrics. Please search the community to get you going, Then, if you get stuck on a particular detail, feel free ask here.

Re: last 12 months bar data

Brett_Bleess — Mon, 10 Feb 2020 20:49:13 GMT

Teny, here is one example, not sure if this is what you needed or not, but to Jonty's point, there are a bunch of other posts, as I did a quick one and got a lot of hits, so if this one is not what you need, just search and work through some of the other posts, as I do expect you will find one that will work for you.

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Displaying-Rolling-Last-12-Months-in-Order-in-Bar-Chart/m-p/347997#M13854

Regards,
Brett