Skip to main content
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

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

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).