Select Exluded Trigger for an If-else condition

572_varuag — Thu, 18 Aug 2022 05:12:36 GMT

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.

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.

Thanks.

Re: Select Exluded Trigger for an If-else condition

marcus_sommer — Thu, 18 Aug 2022 10:52:03 GMT

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

topic Re: Select Exluded Trigger for an If-else condition in App Development

Select Exluded Trigger for an If-else condition

Re: Select Exluded Trigger for an If-else condition