Discussion board where members can get started with QlikView.
I have a multi box with the following fields and corresponding values:
If i want to exclude 'Patent Analytics' from showing in the multi box, i am using the following expression for the multi box:
=if(_View <> 'Patent Analytics', _View) with the following results where this field value has been excluded from the multi box.
How do i exclude multiple field values, say i want to add 'FDA Analytics' and 'Shopping Analytics' to the exclusion list, what will be the resulting expression like?
For multi-value comparison match() is a better option. try like:
If( Not Match(_View, 'Patent Analytics' , 'FDA Analytics') , _View)
You can put as many values as you want in match() to compare.
View solution in original post
may be like this:
=if(_View <> 'Patent Analytics' or _View <> 'FDA Analytics', _View)
Many thanks Balraj, the recommendation does not work, with that, the multi box lists 'Patent Analytics' as the only field value although it should be excluded.
Many thanks Tresesco, that works well
If(Match(_View, 'Patent Analytics' , 'FDA Analytics') =0, _View)
hope this help you
Thank you Ahmar