Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Line chart and date range

Hi,

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.

forecast.PNG

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!