topic Re: Bookmark - Exclude all values containing specific text? in QlikView

Bookmark - Exclude all values containing specific text?

Wed, 18 May 2011 14:50:06 GMT

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.

Re: Bookmark - Exclude all values containing specific text?

fosuzuki — Thu, 19 May 2011 11:02:04 GMT

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

Re: Bookmark - Exclude all values containing specific text?

hectorgarcia — Wed, 05 Sep 2012 17:38:39 GMT

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???