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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Updating bookmarks selecting an exact value, not as a substring.

Updating a bookmark to select todays date.

I have a trigger on document load that will clear all selected fields, select the current year, month and day and save it as a bookmark, then clear all fields and select the previous working day's year, month and day and replace the bookmark. I leave this selection active so that's what the user gets initially.

When the document is opened the selection shows fine, however it doesn't work when actually using the bookmarks.

The year and month work, however for the days selected its selecting 2, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29. It seems to be getting anything starting with a 2, not just 2.

The formula for selecting todays date is "=Day(Today())"

It seems like this works when updating what is selected, but as soon as it's saved as a bookmark it breaks.

How can I fix this issue so that I only select 2 (because today is the second).

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Can you post an example? Read this document for more information:


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

See attached for a simple example.

There is a single field with numbers 1 - 31.

An action button clears all selections, selects 2 then replaces a bookmark.

Once pressed 2 is correctly selected, but using the bookmark 2 as well as 20, 21 ... 29 are also selected.

Thanks for any help!

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

I can't reproduce your problem. The bookmark always selects only 2 here.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Hmm, that's odd. I'm on the version of qlikview as below, not sure if that

makes a difference.

Client Build Number 11.0.11440.0409

Server Build Number -

QlikTech Product QlikView 64-bit Edition (x64)

CPU Target x64

I'm working around it for now by using action buttons on all sheets

instead of relying on the bookmarks, but it would be nice to get some kind

of resolution. Possibly I just need to update to a later version (if there

is one).