This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
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
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.
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.