Automation

[integrationmadeeasy]

Hi, I upgraded tot Qlik SaaS Enterprise to use automation, more specific reporting.

I managed to make the automation, added the sheet and made 2 selections where one of them os not working.

The dataset contains a field that I use to filter in the app "Datum" and I want the selection in automation to be today minus 3 days. I don not understand what to do.

[AfeefaTk · Accepted solution]

Hi @integrationmadeeasy 

Thanks for reaching out

You can Select 'Add formula' and search for the Date formula in the Formula picker that pops up.

Configure the Date formula as follows:

You can specify the DateTime format depending on your requirement

More information on Formatting datetimes can be found here

Hope this helps!

Thanks!

Afeefa TK