Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Qlik Sense line chart forecast min-max

Hello experts,

Can we build this line chart in QlikSense?

Capture.PNG

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.

14 Replies
Highlighted
Partner
Partner

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/

 
Highlighted
Contributor III
Contributor III

Hi @Quy_Nguyen ,
 

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

Highlighted
Creator III
Creator III

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

Highlighted
Contributor III
Contributor III

Hi Quy_Nguyen,

Thanks for your solution, i'll try later

Highlighted
Contributor II
Contributor II

nandini_chatter_0-1600131147074.png

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