Cutting off zero values on a cumulative chart

[richard_gale]

Hi - I have two Measures on my chart - one is already defined by month through until the end of the year (Budget+R&O) but the other (GECS Actuals) only has data added at the end of each month. I want to chart the data using the Accumulation Expression Modifier to show a run-rate trend line for the GECS Actuals.

The problem I have is that the GECS Actuals line flat-lines at the end of the data-set, which screws up the trend line. How can I limit the line to finish where the data ends? I've tried an If statement in my chart Expression =If((Sum(GECS Actuals)>0),Sum(GECS Actuals)) but that doesn't work. Does anyone have any suggestions to cut off the GEC Actuals line at March and have the trend line consider Jan-Mar data only for the full year?

Thanks, Richard

[vikasmahajan]

Hi,

Refer this link

https://community.qlik.com/t5/New-to-Qlik-Sense/Budget-vs-sales/td-p/1510548

, in your script you can create flags like type = 'ACTUAL'  and Type = 'Budget' and then use this in your set analysis 

https://community.qlik.com/t5/App-Development/Actual-vs-Budget-Scenario/td-p/1772667

Vikas