# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Highlighted
Not applicable

## Rolling 12 Month with dynamic dimension selections

Hi all,

I have an issue in set analysis for rolling 12 month calculations (please see attached qvw).

My calculations is already correct for all region, but when i selected one region the value is not changes because i'm using 1=static in my set analysis because if i remove or change it to \$ then the expression will only calculated for current sales only.

So..how i can achieved rolling 12 month calculations that can also move with others selected dimension (needed urgent).

Thank you..

Tags (6)
1 Solution

Accepted Solutions
Not applicable

## Re: Rolling 12 Month with dynamic dimension selections

Hi Shusil,

Thank you for the sample, its help me.

I've been analyzed more on yours sample, i found that its not cover the day. For example, if on July 2011 the transaction ended at day 17 then for July 2010 it will not take on the whole day of July 2010. Why? because i've found some value is wrong, my early assumption is because of that .

So..I've made a final solutions based on yours qvw and my qvw.

Thanks

4 Replies
New Contributor II

## Re: Rolling 12 Month with dynamic dimension selections

Hi Dwi,

I am new to qlikview tool but i have tried some what .

Use month as dimension and in expression use this

//For Current Year:-=Sum({\$<Year={\$(=Max(Year))}>}Sales)

//For last Year:-=  =Sum({\$<Year={\$(=Max(Year)-1)}>}Sales)

//For Diff:-=   (Column(1)-Column(2))/Column(1)

i have attached the file here

Regards,

Mohanraj Subramanian.

Not applicable

## Re: Rolling 12 Month with dynamic dimension selections

Hi,

Sum({\$<Year={\$(=Max(Year))}>}Sales)  = Sum(Sales)

thats not calculated 12 month back

Honored Contributor II

## Re: Rolling 12 Month with dynamic dimension selections

Hi,

i have similar for 6 months

PFA

HTH

Sushil

Not applicable

## Re: Rolling 12 Month with dynamic dimension selections

Hi Shusil,

Thank you for the sample, its help me.

I've been analyzed more on yours sample, i found that its not cover the day. For example, if on July 2011 the transaction ended at day 17 then for July 2010 it will not take on the whole day of July 2010. Why? because i've found some value is wrong, my early assumption is because of that .

So..I've made a final solutions based on yours qvw and my qvw.

Thanks