topic Re: Dynamic filter in automation in Qlik Automate

Dynamic filter in automation

martinpohl — Wed, 08 Dec 2021 07:50:51 GMT

Hi,

can anybody explain how to set a dynmic filter in application automation?

I want to select in field Year month the value of actual month, in expression it would be date(today(),'YY MMMM').

Thank you

Re: Dynamic filter in automation

Ionut_Dumitrascu — Wed, 08 Dec 2021 08:32:30 GMT

Hi @martinpohl ,

In order to dynamically get the current year - month, you can use the following formula:

{date: 'now', 'Y-m'}

where 'now' gets the current date value and 'Y-m' is the output format which can be adjusted to match your needs. I also attached an example that you can upload in a new automation to check it out.

Regards,

Ionut

Re: Dynamic filter in automation

Ionut_Dumitrascu — Wed, 08 Dec 2021 12:34:43 GMT

Hi @martinpohl ,

Please also check the following articles that explain how to work with formulas and dates in an automation.

Kind regards,
Ionut

Re: Dynamic filter in automation

martinpohl — Wed, 08 Dec 2021 16:00:51 GMT

Great, first check was ok.

But there is a problem with date format.

I'm using

date(monthstart(Usingdate),'MM YYYY') as MonthYear.

when I'm using now and format mm yyyy, it doesn't work.

I've checked the values in valuelist (do lookup). There I can see:

12 2021 (44531)

11 2021 (44501)

As I know, date and month information in fields are stored as dual, so you can see the day also in the value.

How can I achive to select the actual month by "select field value"?

Regrads

Re: Dynamic filter in automation

martinpohl — Thu, 09 Dec 2021 11:46:04 GMT

after changing to

text(date(monthstart(Usingdate),'MM YYYY')) as MonthYear

and set filter to

m 20y

it works!