Prophet function with dynamic dimension selection

[kokyeesiang]

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-Start you 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:

• OS [e.g. Windows Server, Linux]
• Qlik Sense Enterprise/ Desktop/ Kubernetes/ QlikView
• SSE Version

Additional context
Add any other context about the problem here.

[nabeel-oz]

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