topic Re: 12 month rolling year over year and month over month in a pivot in QlikView

12 month rolling year over year and month over month in a pivot

Tue, 01 Oct 2013 14:02:28 GMT

Hi,

I am displaying a pivot with year month dimension for 12 months and the business (bamount) done for this months. I am also showing the month on month variation. But am not able to show year over year variation for each of this year month combination.

For eg. if the business for 2012-01 is 100 and that for 2013-01 is 200 then the yearly variation is 100 %.

Attached is the sample doc.

Thanks in advance

Lax

Re: 12 month rolling year over year and month over month in a pivot

Gysbert_Wassenaar — Tue, 01 Oct 2013 17:13:05 GMT

I think you'll need an AsOf table. See attached example.

Re: 12 month rolling year over year and month over month in a pivot

Fri, 04 Oct 2013 13:00:24 GMT

Thanks a lot.

Lax