Rolling 12 Month with dynamic dimension selections

[#1]

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..

[mohanrajsubrama]

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.

[#3]

Hi,

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

thats not calculated 12 month back

[sushil353]

Hi,

i have similar for 6 months

PFA

HTH

Sushil

[#5 · Accepted solution]

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