nabeel-oz
commented
4 years ago Hi @kokyeesiang, yes this is possible by creating a Forecast Calendar in the load script and using date dimensions from this specially prepared table for the forecasts. This technique is described in the documentation below: https://github.com/nabeel-oz/qlik-py-tools/blob/master/docs/Prophet.md#use-prophet-with-your-own-app
Function Prophet function for forecast.
Describe the bug I'm using the prophet function for the forecast. I would like to know is there a way to make the forecast reflect according to any dimension selection that I made?
So far I've tried with hardcoded dimension value in set analysis work. For eg. Pytools.Prophet(DATE,If($(vVisible) = 1,sum({<State={'ABC'}>}SALES_AMT)),'freq=D,return=y_then_yhat')
But I would like to know would it be possible the forecast function work without doing the hardcoded set analysis value in measurement?
Expected Result: Forecast work when user made any dimension filtration. Eg. selection made on any dimension value of state then the forecast will display according to the selection made.
Appreciate any advice/feedback.
Thanks.
Full error message from Python Provide full stack trace for the error. If using
Qlik-Py-Startyou can provide screenshots from the terminal. Make sure to go all the way up to the start of the errors. Alternatively, you can provide the latest log files from../qlik-py-tools/qlik-py-env/core/logs.Error message in Qlik Provide a screenshot of the error message in Qlik.
Expression or load script used in Qlik Provide a screenshot of the expression or load script where the SSE is being used in Qlik.
Environment:
Additional context Add any other context about the problem here.