topic Re: Rolling Month Data in QlikView

Rolling Month Data

manojkulkarni — Wed, 23 Jul 2014 12:07:20 GMT

Hi Everyone,

I have one requirement, where in we need to show 12 months cumulative data over 12 months.

eg: for each month we need to calculate data backward for 12 months & same has to be continued for rolling 12 months.

Your solution is much appreciated.

sujeetsingh — Wed, 23 Jul 2014 12:12:44 GMT

Where you want the rolling presentations to be in your UI or script.

There are different way to implement --In UI for bars there is option of accumulation in qlicview.

--IN Script

--In UI for bars there is option of accumulation , in Pivot table there are logic of expressiosn to handle

manojkulkarni — Wed, 23 Jul 2014 12:18:28 GMT

required in charts. Accumulation option will accumulate only the data available in chart. But my requirement is,

if Starting point is Jan14, then data should be calculate from last 11 months i.e from Feb13 to Jan14.

Like this i need show bar chart for 12 months. Jan14 to Dec14.

In every point, it should calculate data for last 12 months.

Anonymous — Wed, 23 Jul 2014 12:22:59 GMT

Hi Manoj,

In chart properties, under Expression tab select the Full accumulation option for you expression.

Hope this will solve your problem.

Regards,

Laxmi

sujeetsingh — Wed, 23 Jul 2014 12:26:50 GMT

You need to go for a logic then