Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
Maybe this could be of help for you:
Calculating trend lines, values and formulas on charts and tables in Qlik Sense
Maybe a more advanced solution is what you need:
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
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.
If this answered your question please mark the appropriate answer as correct. If not please feel free to ask further questions to clarify...
Can you please guide on how to use this extension, It says error occured when retrieving data from R