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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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???