Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

4 Replies
mohanrajsubrama
Contributor II
Contributor II

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
Author

Hi,

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

thats not calculated 12 month back

sushil353
Master II
Master II

Hi,

i have similar for 6 months

PFA

HTH

Sushil

Not applicable
Author

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

View solution in original post