Button. Select values in field with expression

mrbalyaqv — Mon, 20 Dec 2021 21:08:46 GMT

Hi all!

First of all, a few words about what I try to achieve. It's possible to create dynamic bookmarks by typing expressions in search field: https://youtu.be/tFyqOigqnUw?t=55
I want to allow users create bookmarks like this by themself. They won't use formulas, so I decided to add some buttons, that will do this.

And this is where I'm stucked now. For button on sheet I go to Actions and navigation. In Action field I choose Select values in field. 'dt' is my field with dates.

For Value I tried a lot of options:
>Date(now())
=dt>Date(now())
='>Date(now())'
same logic as above, but with variable instead of expression itself.
Nothing works.
But when I replace >Date(now()) with straight date like >02.06.2020, it works.
When I use =Date(now()) it works again.
So, why >Date(now()) doesn't work?
I'm using a trial version on qlikcloud.com if it matters.

Re: Button. Select values in field with expression

mrbalyaqv — Mon, 06 Jul 2020 13:55:29 GMT

In this case I found a workaround: I created a new field in a load
if(dt>Date(now()), 1, 0) as future_date_flag
And then just used that field in navigation button.

Marked as solution while there's no answer on actual question.

topic Button. Select values in field with expression in App Development

Button. Select values in field with expression

Re: Button. Select values in field with expression