Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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..

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

sushil353
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