Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

forecasting in qliksense

Hello,

I have a line chart with as dimension Year Month (ex . 201802) and in my expressions Count(Servers) as volume

Now for the volume I would like to make a Forecast (up to 6 months)

Can anyone help me with same.

11 Replies
petter
Partner
Partner

manoj2102
Contributor III
Contributor III
Author

Hi Petter,

Thanks for response but this is giving me trendline only for monthyear for which Actuals(Count(Servers)) are present

I want that trend should show me values for next 6 month to forecast about future requirments of servers in next 6  months ie( from June 2018 to Dec 2018)

I want something similar to this

petter
Partner
Partner

You can use the LINEST function(s) in Qlik Sense to calculate a forecast. The LINEST is a linear regression function and I belive that it could be suitable for your case.

petter
Partner
Partner

If this answered your question please mark the appropriate answer as correct. If not please feel free to ask further questions to clarify...

bhadraka1234
Contributor II
Contributor II

Can you please guide on how to use this  extension, It says error occured when retrieving data from R

cookiejest
Partner
Partner

Hey we created a predictive line chart extension for qlik sense just for this use case. It can do things like linear, ARIMA and others. Dynamically of the data 🙂 Check it out.

predictive line chart for qlik sense

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

 

GraceGao
Creator
Creator

Hi Cookiejest

i have used below predictive line chart, everything is ok, However, i have published to the stream, and access denied when opening the sheet with predictive line chart. do you know how to fix it? Thanks.

cookiejest
Partner
Partner

Hey!

This is unlikely to do with the extension itself but rules engine security
on the extension?