topic Re: Automation in Qlik Automate

Automation

integrationmadeeasy — Tue, 29 Nov 2022 07:48:09 GMT

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.

Re: Automation

AfeefaTk — Tue, 29 Nov 2022 09:12:02 GMT

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