topic Re: Add variables to the button in Qlik Automate

Add variables to the button

Mahdi_16 — Mon, 27 Feb 2023 15:42:34 GMT

Hello,

I would like to find dates greater or less than one dimension.
I have to do it in from a button to select a certain type of date in a my graph.

My goal is to select dates less/superio or equal than 60 days old, in the action i select this : "Select values that match the search criteria" and I write this in the values: '$(=>Date(Today()-30))'

I even use it with date#, and I adapt the format date. Also, I can't have access or create variables.

Someone have solution for this question ? Pls.

Thanks,

Re: Add variables to the button

Or — Mon, 27 Feb 2023 15:47:52 GMT

I'm not sure where variables come into play here, but if you want to select e.g. the last 30 days, try:

='>='&Date(Today()-30)

Re: Add variables to the button

Frank_S — Tue, 28 Feb 2023 00:05:38 GMT

Try this

Create a filter pane using your 'date' field
In the search field for your 'date' filter pane object paste
- {<Date={"= Date = today()-30"}>}
Then save the selection as a bookmark.
And finally set your bookmark as the default bookmark.

Kind regards...