topic Re: Rolling 3 months in chart in QlikView

Rolling 3 months in chart

Tue, 23 Aug 2016 08:52:31 GMT

I have created the below chart with below information:-

Dimension : Claim_Month

Expression: count({<CLAIM_DATE={'>$(=AddMonths(Max(CLAIM_DATE),-3))'}>} Distinct CLAIM_ID)

This chart is showing me the max of month and previous two months always.

I wanted to show, If I select any month from top, then the chart should show, the selected month and previous 2 month in the chart.

Suppose, if I am selecting April from top list box, then my chart dimension should show Apr, Mar, Feb.

How can I do this? Please help me at the earliest.

Re: Rolling 3 months in chart

sunny_talwar — Tue, 23 Aug 2016 11:50:21 GMT

Can you try it with this expression:

Count({<CLAIM_DATE={'>$(=AddMonths(Max(CLAIM_DATE),-3))'}, MonthField = >} Distinct CLAIM_ID)

Re: Rolling 3 months in chart

arulsettu — Tue, 23 Aug 2016 11:51:20 GMT

try this

count({<CLAIM_DATE={'>$(=AddMonths(Max(CLAIM_DATE),-3))<=$(=max(CLAIM_DATE))'}>} Distinct CLAIM_ID)

Re: Rolling 3 months in chart

Wed, 24 Aug 2016 09:00:43 GMT

Hi Sunny, Thankyou for ur assistance. But this is not giving me the right month sets. Please help

Re: Rolling 3 months in chart

Wed, 24 Aug 2016 09:02:04 GMT

Hi Settu,

Your solution is not giving me the right month sets. When I select any month from Claim_Month, then my chart dimension should show the selected month and previous two months. Please help.

Re: Rolling 3 months in chart

arulsettu — Wed, 24 Aug 2016 09:08:20 GMT

can you post you app

Re: Rolling 3 months in chart

sunny_talwar — Wed, 24 Aug 2016 09:41:07 GMT

Would you be able to elaborate so to what you are getting and what do you expect to see?

Re: Rolling 3 months in chart

agomes1971 — Wed, 24 Aug 2016 09:46:34 GMT

Hi,

please see this article

Calculating rolling n-period totals, averages or other aggregations

HTH

André Gomes

Re: Rolling 3 months in chart

saimahasan — Wed, 24 Aug 2016 09:55:49 GMT

use this expression:

count({<CLAIM_DATE={'>$(=max(CLAIM_DATE)-3)<=$(=max(CLAIM_DATE))'}>} Distinct CLAIM_ID)