Qlik Community

Qlik Sense App Development

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

manoj2102
New 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.

6 Replies
MVP
MVP

Re: forecasting in qliksense

MVP
MVP

Re: forecasting in qliksense

manoj2102
New Contributor III

Re: forecasting in qliksense

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

MVP
MVP

Re: forecasting in qliksense

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.

MVP
MVP

Re: forecasting in qliksense

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

bhadraka1234
New Contributor

Re: forecasting in qliksense

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

Community Browser