topic Re: How to do Rolling Year in QlikView

How to do Rolling Year

Mon, 17 Oct 2011 21:26:25 GMT

Hi,

I need to generate a growth graph by category of the (Rolling year) vs (Rolling Last Year), but i can´t put this dimensions in a graph because every Rolling Year i calculate separately,

the first dimension that i want to represent is the growth of the more actually 12 months between the 12 months preceding the current in the dimension

from the year more actually and to represent for a range of 5 years

Attached image to represent the type of graphic that i need

Re: How to do Rolling Year

its_anandrjs — Tue, 18 Oct 2011 04:09:19 GMT

Hi,

See the attached sample file might be you have to use like this for rolling months

Rgds

Anand

Re: How to do Rolling Year

Tue, 18 Oct 2011 15:28:04 GMT

Hi Anand,

Thanks for your coment ... but i´m searching for anothe thing.... i´m searching for a graph the growth of the rolling year actual versus rolling year of the last year in a bar graph with the dimension "year"

i attach an example of the pivot table that i have now at this moment...

thanks !!