Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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