Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
New Contributor

Line chart and date range


I'm trying to make a Vizlib line chart for my forecasting model. But as you see below, as soon as the future dates begins, Actual values hits zero.


How can I make a set analysis date range only for Actual values, thus I only get a range of dates where I also have records.

My code

Forecast = Sum({<hovedbranche_kode={$(vValgtBranche)}>}yhat)

Actual values = Sum({<hovedbranche_kode={$(vValgtBranche)}>}[Brancheomsætning])

I have records until 01/08/2018.

Thanks in advance!