Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
'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]
And there it is. Thank you!
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
I don't know how the pdf export is created and how that is triggered. Can you start a new discussion for this question?
thanks for the quick response
I started a new discussion: Exclude Value in PDF Export