Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Jun 7, 2023 3:25:13 AM
Oct 25, 2017 9:21:47 AM
A user wants to select all the values from a field except values "A", "B", and "C". One approach is to add a listbox/filter pane into the sheet, select the values "A", "B", and "C", and choose Select Excluded.
To apply the selection multiple times in the future, the user can save the selection as a bookmark.
Issues will occur if new data is added to the field via reload. Once the user is applying the selection from the bookmark to the field after the reload, those newly added values will also be excluded.
This is the expected behaviour of Qlik/QIX Engine. In fact, you can easily check what the bookmark really saves when you created it (you can apply it and check the Current Selection box) and you will see that it has saved the selected values after the initial Select Excluded operation, i.e. Engine only stores selections but not the action (Select Excluded) into the bookmark.
Therefore, when you apply the bookmark in the future, those new values added afterwards will be excluded as well, because the values were not included in the selection initially when the bookmark was created.
There are other ways to exclude values from a field and to create a bookmark without being affected by data set change. The simplest is the Advanced Search function.
Go back to the example in the beginning. The user can use the following search string to exclude the 3 values: =not wildmatch(FieldName,'A'|'B'|'C') . Apply this to a listbox / filter pane and create a bookmark out of it. You will see from the Current Selection box that the actual search string is stored in the bookmark, because Search is a type of selection.
Now no matter what data set change the application might have: the same search string will be applied and give you the expected result.
You can test this with the QlikView application attached in this article. But note that the same concept applies for Qlik Sense as well.
Qlik Sense Enterprise on Windows
QlikView
Qlik Sense Desktop
It is simpler to use -A -B -C as a selection. And easier to remember
This also gets stored within the bookmark expression