Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

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

Re: 12 month cumulative sum with variable interference

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 !

 

 

2 Replies
Partner
Partner

Re: 12 month cumulative sum with variable interference

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 !

 

 

Partner
Partner

Re: 12 month cumulative sum with variable interference

It worked perfectly ! thanks for your help on this one