Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Quy_Nguyen
Specialist
Specialist

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
cookiejest
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/

 
adambrian
Contributor III
Contributor III

Hi @Quy_Nguyen ,
 

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

Quy_Nguyen
Specialist
Specialist
Author

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
Contributor III
Contributor III

Hi Quy_Nguyen,

Thanks for your solution, i'll try later

nandini_chatter
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