Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
572_varuag
Contributor
Contributor

Select Exluded Trigger for an If-else condition

Hello, 

I am in the process of eliminating selections made with the help of macros and convert them into field event trigger based selections. 

One scenario in this is proving to be very difficult to convert. As you can see the macro script contains an If-else condition where in the first condition, the select excluded functionality is being used. 

572_varuag_0-1660799296417.png

I was able to replicate the If-else condition but how do I get QV Triggers to exclude the values selected in the last line of my if condition. 

572_varuag_1-1660799425777.png

Thanks.

 

 

Labels (1)
1 Reply
marcus_sommer

An exclusion could for example be reached with a heading minus-sign. Just play with it directly on a list-box. If you could set the wanted selections and comprehends the logic you may adapt it to the macro- and/or action-stuff.

But I suggest to avoid such approaches in general because of the needed complexity and efforts to create and maintain such logic and the worse usability which comes often with it. Within a normal data-model such stuff won't be needed because everything is appropriate related to each other and could be directly selected and for advanced views a set analysis could be applied to ignore/overwrite selections - especially the p() and e() functions are very powerful.

Just for reference see:

Macros are Bad - Qlik Community - 1466215

Let the User Select - Qlik Community - 1463978

- Marcus