Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
reivax31
Partner - Creator III
Partner - Creator III

12 month cumulative sum with variable interference

Hi Qlikers,

I have a new challenge for you. I would like in a chart/table to perform a cumulative sum on 12month but depending on some variable value (v1, v2, etc...)  we peek either the "theoritical" value or the "real" value.

Attached you will find the expected results in an excel file to have a better look. I also made a test App.

Thanks for your help

 

1 Solution

Accepted Solutions
adrien_marchadi
Partner - Contributor II
Partner - Contributor II

Hey Reivax !

Find attached an app with some answer ...
I first calculated all rangesums (real, theorical and combined using variables), and then the rangesumdeviation

Note that I used this condition in the deviation :
if(rangesum real <> rangesum combined, rangesum combined / rangesum theorical -1)

Not really understand why you would want to do that, but that should do the trick !

 

 

View solution in original post

2 Replies
adrien_marchadi
Partner - Contributor II
Partner - Contributor II

Hey Reivax !

Find attached an app with some answer ...
I first calculated all rangesums (real, theorical and combined using variables), and then the rangesumdeviation

Note that I used this condition in the deviation :
if(rangesum real <> rangesum combined, rangesum combined / rangesum theorical -1)

Not really understand why you would want to do that, but that should do the trick !

 

 

reivax31
Partner - Creator III
Partner - Creator III
Author

It worked perfectly ! thanks for your help on this one