Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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