topic Re: Limit selection possibilities in selection box in QlikView

Limit selection possibilities in selection box

Fri, 02 Mar 2012 10:36:43 GMT

Hi!

I have 5 different factories but I only want 4 of them to be visible in my selection box. Is there any way of limiting the selections to be visible in my selection box?

Thanks!

Limit selection possibilities in selection box

CELAMBARASAN — Fri, 02 Mar 2012 10:43:37 GMT

Hi,

Yes its possible.Try with this

=if(WildMatch(Factory,'Factory1','Factory2','Factory3','Factory4'),Factory)

as a expression in listbox

Hope it helps

Celambarasan

Limit selection possibilities in selection box

swuehl — Fri, 02 Mar 2012 10:51:21 GMT

Or just exclude the one you don't want to show:

=if(Factory <> 'FactoryNotToShowName', Factory)

as the list box field expression (open the drop down field list in general tab, select <Expression> from the very end).

Limit selection possibilities in selection box

jagan — Fri, 02 Mar 2012 10:59:44 GMT

Hi,

This is the better option to exclude one Factory

=if(Factory <> 'FactoryNotToShowName', Factory)

Regards,

Jagan.

Re: Limit selection possibilities in selection box

Fri, 02 Mar 2012 11:00:15 GMT

Thanks!!

Re: Limit selection possibilities in selection box

Fri, 02 Mar 2012 11:00:15 GMT

Thanks a lot!!

Limit selection possibilities in selection box

CELAMBARASAN — Fri, 02 Mar 2012 12:44:17 GMT

Hi,

Close this discussion by marking as correct answer.

Celambarasan

Re: Limit selection possibilities in selection box

Anonymous — Wed, 09 Apr 2014 18:22:54 GMT

How about more than one exclusion?

Re: Limit selection possibilities in selection box

Wed, 09 Apr 2014 18:26:32 GMT

In order to handle more than one exclusion you could just do =if(Factory <> 'FactoryNotToShowName' AND Factory <> 'FactoryNotToShowName2', Factory) ... I think in set analysis something like =only({<Factory -= {'FactoryNotToShowName', 'FactoryNotToShowName2'}>}Factory) would work as well.

Re: Limit selection possibilities in selection box

Anonymous — Thu, 10 Apr 2014 12:20:51 GMT

Thank you Christian, a great help.