topic Re: Rolling 12 Month with dynamic dimension selections in QlikView

Rolling 12 Month with dynamic dimension selections

Wed, 27 Feb 2013 05:45:26 GMT

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

Re: Rolling 12 Month with dynamic dimension selections

mohanrajsubrama — Wed, 27 Feb 2013 06:50:11 GMT

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.

Re: Rolling 12 Month with dynamic dimension selections

Wed, 27 Feb 2013 07:00:49 GMT

Hi,

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

thats not calculated 12 month back

Re: Rolling 12 Month with dynamic dimension selections

sushil353 — Wed, 27 Feb 2013 07:29:32 GMT

Hi,

i have similar for 6 months

PFA

HTH

Sushil

Re: Rolling 12 Month with dynamic dimension selections

Wed, 27 Feb 2013 09:24:17 GMT

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