topic Select Excluded trigger for multiple exclusions in QlikView

Select Excluded trigger for multiple exclusions

Thu, 06 Apr 2017 15:49:43 GMT

Hi all,

I'm wondering if there is an easy way to do this. I'd like to select all items from a field except two. The field is Category description. When I select 'Adjusting Entry' from the field I'd like to use a trigger to select everything that is available in that field based on my selections besides two 'AP' and 'Consolidated' (Both under JE Category Description Field). Is this possible. When I do a select Field than Exclude selected i can only do one of the two values I'm trying to exclude and it also selects all of them overriding previous selections. Any assistance would be greatly appreciated.

Thanks,

Re: Select Excluded trigger for multiple exclusions

Thu, 06 Apr 2017 15:56:34 GMT

I actually realized it doesn't look to be overriding selections but I still don't know how to exclude another field

Re: Select Excluded trigger for multiple exclusions

Gysbert_Wassenaar — Thu, 06 Apr 2017 16:52:33 GMT

You can use a Select in Field action to select more values. Use as search string ("AP" | "Consolidated")