topic Re: Limit List box in QlikView

Limit List box

Anonymous — Fri, 19 Sep 2014 11:16:07 GMT

Hi guys,

I would like to limit a list box to certain values a little like an IN statement in SQL. Can this be done within an expression?

I have a list like this

Say i would like to see just Aprons and Bags in the list.

Can this be done?

thanks

tresB — Fri, 19 Sep 2014 11:19:50 GMT

=If(WildMatch(Type, '*Apron*', '*Bag*') ,Type)

PrashantSangle — Fri, 19 Sep 2014 11:22:37 GMT

Hi,

Write Expression in list Box

If(Wlidmatch(Type,'Apron*','Bags*'),Type)

Regards

ychaitanya — Fri, 19 Sep 2014 11:31:01 GMT

TRY

if(Match(Field,Aprons,'Bags'),Country,Null())

in the expression in the List Box Field Definiton

Anonymous — Fri, 19 Sep 2014 12:06:25 GMT

Brilliant!

Thanks guys