topic Re: Selection in bookmarks does not work when new values arrive in QlikView

Selection in bookmarks does not work when new values arrive

Fri, 28 Feb 2014 16:54:43 GMT

Here is what happens:

User selects "Exclude selection" to filter down a certain list to show all values except few that he/she is not interested in.
User creates a bookmark for this selection.
New data set is added and the list now has more values.
When user selects the same bookmark, the values that are excluded are the ones that we intentionally don't want AND the ones that are new to the list.

We have many users in the system so using code for each bookmark is out of question.

This is only needed for "exclude selected".

Desired outcome:

List shows all values (including new ones) except the ones that the user initially excluded.

Help needed:

What can be done so that selections that are in bookmark go through the same steps again rather than just show the selections that were bookmarked. What should/can the user do differently to get the desired outcome.

Re: Selection in bookmarks does not work when new values arrive

Anonymous — Fri, 28 Feb 2014 17:03:27 GMT

Apparently using bookmark is not a reliable solution here, because the data changes.

Maybe it is better to use a variable that keeps the list of the values to exclude. In this case you can create a button (or text box) with actions "Select In Field" (and use variable here), followed by "Select Excluded".

Re: Selection in bookmarks does not work when new values arrive

Andrea_Ghirardello — Thu, 02 Oct 2014 09:04:09 GMT

Try to use an advanced search in order to exclude values and, once you have applied it, save the selection as a bookmark.

Then, load other values to the field and apply the bookmark...new values will be affected by the bookmark.

Take a look to the attachment.

Re: Selection in bookmarks does not work when new values arrive

evan_kurowski — Sun, 20 Sep 2015 16:11:36 GMT

Yes, I agree with Andrea's approach.

The key distinction is the bookmark formed from advanced search evaluates like a series of WHERE clauses, where a standard bookmark is an explicit list of values to match.

The standard bookmark will remain static and not change according to new data, while the one formed from advanced search will re-evaluate every time. Very neat feature.