Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
Can you post an example? Read this document for more information:
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!
I can't reproduce your problem. The bookmark always selects only 2 here.
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).