Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

chitemerere
Valued Contributor

Restricting field values shown in a multi box

I have a multi box with the following fields and corresponding values:

Screen Shot 2015-12-16 at 10.16.18.png

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.

Screen Shot 2015-12-16 at 10.16.01.png

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.

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Restricting field values shown in a multi box

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

6 Replies
balrajahlawat
Esteemed Contributor

Re: Restricting field values shown in a multi box

may be like this:

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

MVP
MVP

Re: Restricting field values shown in a multi box

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

chitemerere
Valued Contributor

Re: Restricting field values shown in a multi box

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

chitemerere
Valued Contributor

Re: Restricting field values shown in a multi box

Many thanks Tresesco, that works well

ahmar811
Contributor III

Re: Restricting field values shown in a multi box

try this

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


hope this help you


Regards

Ahmar

chitemerere
Valued Contributor

Re: Restricting field values shown in a multi box

Thank you Ahmar