Hi there henrynoh,
in qlikview it is possible to use an expression inside a LISTBOX
i have attached an example
the list box simply has an expression that you wanted
=if(Expression1 < 0 AND index( Dim1 , 'DG') > 0,'Includeed','Excluded')
this way the user have a familiar control (listBox) and you are using qlikview's methods which is the best when ever it is possible.
as a rule of thumb i try everything i can to not use macros.
most simple automation can be done via the triggers and actions system
its not that i say don't use macros , i only say try to train your mind to think qlikview ways before thinking macro ways:)
have a nice day
One click Exclude-Include.qvw 153.5 K