topic Restricting field values shown in a multi box in QlikView

Restricting field values shown in a multi box

Anonymous — Wed, 16 Dec 2015 08:29:48 GMT

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?

Regards.

Re: Restricting field values shown in a multi box

Anonymous — Wed, 16 Dec 2015 08:32:26 GMT

may be like this:

=if(_View <> 'Patent Analytics' or _View <> 'FDA Analytics', _View)

Re: Restricting field values shown in a multi box

tresB — Wed, 16 Dec 2015 08:36:52 GMT

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.

Re: Restricting field values shown in a multi box

Anonymous — Wed, 16 Dec 2015 08:41:38 GMT

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.

regards

Re: Restricting field values shown in a multi box

Anonymous — Wed, 16 Dec 2015 08:49:54 GMT

Many thanks Tresesco, that works well

Re: Restricting field values shown in a multi box

ahmar811 — Wed, 16 Dec 2015 08:52:04 GMT

try this

If(Match(_View, 'Patent Analytics' , 'FDA Analytics') =0, _View)

hope this help you

Regards

Ahmar

Re: Restricting field values shown in a multi box

Anonymous — Wed, 16 Dec 2015 09:13:16 GMT

Thank you Ahmar