Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
songchrist
New Contributor II

Line chart accumulation

Hello,

I'm trying to do a Line chart with 3 expressions: Actual expense, Budget, Forecast.

The dimension is month.

The budget and forecast are defined until December. The Actual expense is updated month to month and is an accumulation.(for instance: on October: the actual expense is the sum of from Jan to Oct. )

When i put it  on the same chart line,  since Budget and Forecast have Nov and Dec data, so it's appeared on the chart. but for the actual expense,  Nov and Dec data is considered as 0, as result, the Oct number appeared on Nov and Dec, since it's an accumulation.

I would like to not have Actual expense appeared on Nov and Dec, and Budget and Forecast keep the same.

Any ideas for this?

Thanks,

1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: Line chart accumulation

Check attached if this is what you want?

Change to this for your Actual expr:

= IF(Sum(Actual) = 0, 0, rangesum(above(sum(Actual),0,rowno())))

9 Replies
vishsaggi
Esteemed Contributor III

Re: Line chart accumulation

Can you share a sample file to look into?

songchrist
New Contributor II

Re: Line chart accumulation

qlik_questions.PNG

Hello, here is an example i made, the "Actuals" is up to date on October, i want the "Actuals" line stop at October. 

vishsaggi
Esteemed Contributor III

Re: Line chart accumulation

We might have to write an expression inside your expression. If you can attach this sample file i can look into it. 

songchrist
New Contributor II

Re: Line chart accumulation

Hi,  i'm sorry, but i'm not sure i'm able to upload the file, i can only insert a file with a URL.

is that normal?

vishsaggi
Esteemed Contributor III

Re: Line chart accumulation

Just follow these instructions to upload.

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

Preparing examples for Upload - Reduction and Data Scrambling

Click on use  advanced editor on top right corner of the reply window then you can see the attach icon in the bottom right of the window upload the file. Capture.PNG

songchrist
New Contributor II

Re: Line chart accumulation

Hello,

Thanks for the instruction. Attached an example.

Thanks

songchrist
New Contributor II

Re: Line chart accumulation

Attached

vishsaggi
Esteemed Contributor III

Re: Line chart accumulation

Check attached if this is what you want?

Change to this for your Actual expr:

= IF(Sum(Actual) = 0, 0, rangesum(above(sum(Actual),0,rowno())))

songchrist
New Contributor II

Re: Line chart accumulation

Yes, it works! Thanks a lot for your help!