Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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???