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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bookmark - Exclude all values containing specific text?

Is it possible in QlikView to have a bookmark that exclude all values in a filter containing a specific text? Let's say that I have a filter contining a lot of strings and I want to exclude all strings containing "XYZ"? I know that I can first search for all strings containing "XYZ" and then do a Select Excluded and then store this as a Bookmark. My problem is however that the number of values in the filter increase over time and I guess that all new values containing "XYZ" will not be excluded when I use my Bookmark but only the ones that were excluded when I created the Bookmark?

I've been trying with someting like <>*XYZ*, !=*XYZ*, NOT *XYZ* but no luck so far.

2 Replies
fosuzuki
Partner - Specialist III
Partner - Specialist III

Hi dempen,

i've found a solution for you, but using one button with triggers. No bookmarks...

Check my attached sample.

Hope this helps you.

Regards,

Fernando

hectorgarcia
Partner - Creator III
Partner - Creator III

why do not use a flag in the script to mark the filds containing the XYA and then you do a bokmark based on that flag???