Qlik Sense line chart forecast min-max

[Quy_Nguyen]

Hello experts,

Can we build this line chart in QlikSense?

From 2018 to 2022 is forecast data. I know that we could create a line chart with 4 measure to display 4 lines, but i want to have the area between min and max colored.

[cookiejest]

Anyone wanting a free example of this (with no user limit) you can use the WoW predictive line chart.

https://blog.webofwork.com/predictive-line-chart-for-qlik-sense/

[adambrian]

Hi @Quy_Nguyen ,
 

Can you share how to create line for forecast, min and max? 

[Quy_Nguyen]

Hi Adambrian,

Sorry for this late reply. Hope you already found the solution for it.

For this kind of forecasting data, I used SSE for the calculation. More info here: https://github.com/nabeel-oz/qlik-py-tools

[adambrian]

Hi Quy_Nguyen,

Thanks for your solution, i'll try later

[nandini_chatter]

Hello Quy_Nguyen,

I found your post very useful. I have requirement to do the same thing in Qlik Sense.

However I already have the Min Max Actual and Forecast values coming in as fields from database. My challenge is to shade the area between Min and Max, something like the image attached. Could you please give some suggestions as to how it can be achieved using Vizlib Line Chart extension. As I understand we do not need to use the advanced section forecasting for this since I already have the forecasted values. 

Any help will be highly appreciated.

Thanks