topic Sheet Event Trigger to Exclude Value in QlikView

Sheet Event Trigger to Exclude Value

Mon, 16 Jun 2014 19:11:35 GMT

I'm trying to create an OnActivate Sheet Event Trigger to exclude values by default.

I can get the field to work to only INCLUDE the value, but I can't figure out how to switch it to only EXCLUDE the value.

Attribute: [car-make_model]

Value to filter excluding: 'Ford, F150'

I've tried going to Settings --> Sheet Properties --> Triggers --> Edit Actions --> Add --> Selection + Select In Field

Field

car-make_model

Search String (I've tried all the following with no success)

-='Ford, F150'

<>'Ford, F150'

= Not ( 'Ford, F150')

=Not 'Ford, F150'

!= 'Ford, F150'

I also tried looking at the option for "Select Excluded", but that only provides a field option and not a value.

Thank you for any guidance that is offered.

Re: Sheet Event Trigger to Exclude Value

Gysbert_Wassenaar — Mon, 16 Jun 2014 19:15:08 GMT

Use two actions. First a Select in Field action to select the value you want to exclude, then a Select Excluded action to invert the selection so the value you selected first is now excluded.

Re: Sheet Event Trigger to Exclude Value

swuehl — Mon, 16 Jun 2014 19:19:06 GMT

'Select Excluded' might help you indeed but in combination with another action, so you need to create two:

1) One action to select 'Ford' and 'F150':

Search string:

(Ford|F150)

2) One action 'Select Excluded' with field [car-make model]

Re: Sheet Event Trigger to Exclude Value

Mon, 16 Jun 2014 19:21:18 GMT

And there it is. Thank you!

Re: Sheet Event Trigger to Exclude Value

t_witzgall — Tue, 30 Aug 2016 12:01:24 GMT

Hi gysbert,

is there a way to do this when making a pdf export?

I have the action implemented for one of my sheets. But I also have a pdf report for this. QlikView should show the same values in the pdf as on the AccessPoint but I cannot find a way to make a simmilar selection.

I know I could select all possible values instead but there may be new ones from time to time and I would have to maintain the report. If possible I would like to avoid this.

Any ideas?

Thanks in advance

Tamara

Re: Sheet Event Trigger to Exclude Value

Gysbert_Wassenaar — Wed, 31 Aug 2016 06:45:38 GMT

I don't know how the pdf export is created and how that is triggered. Can you start a new discussion for this question?

Re: Sheet Event Trigger to Exclude Value

t_witzgall — Wed, 31 Aug 2016 07:12:40 GMT

thanks for the quick response

I started a new discussion: Exclude Value in PDF Export