Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
mrbalyaqv
Contributor III
Contributor III

Button. Select values in field with expression

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.

mrbalyaqv_0-1591133330921.png

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.

 

 

1 Solution

Accepted Solutions
mrbalyaqv
Contributor III
Contributor III
Author

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.

View solution in original post

1 Reply
mrbalyaqv
Contributor III
Contributor III
Author

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.