Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.