Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
nk16_
Contributor II
Contributor II

How to combine actuals with forecast for remaining period and be with cumulative line

Hi All,

I have a question about How to combine actuals with forecast for remaining period and be with the cumulative line.

I have to measures: Forecast and Actual and 2 line charts.

 1 showing actual sales (up to the end of this month) and 1 showing forecast sales (from this month to the end of the year).The Actual should be visible until now and the Forecast should be visible after today.

I want to combine them in one line and the line to be cumulative. 

For the cumulative and be visible only until today, I'm using expressions like this:

If(date<=MonthStart(ReloadTime()),RangeSum(Above(TOTAL Sum(Actuals),0,rowno())))

Many thanks.

 

 

1 Reply
edwin
Master II
Master II

create a cumulative of Actuals,
in a second expression, add the cumulative of Forecast to the total of actuals.
make sure Forecast starts where actuals end (today()) with zero forecast amount so that the 2 charts are connected. 

check out the attached.