topic Re: List box restriction in QlikView

List box restriction

Wed, 21 Jan 2015 05:37:48 GMT

Hi ,

Can we restrict the value in list box? Such as we just want to show the name with prefix L and hide the other name.

Many thanks and thanks in advance!

br,

Lisen

Re: List box restriction

jagan — Wed, 21 Jan 2015 05:51:53 GMT

Hi,

Try this expression in list box

=Aggr(If(Name LIKE 'L*', Name), Name)

Regards,

Jagan.

Re: List box restriction

robert_mika — Wed, 21 Jan 2015 06:00:43 GMT

Hi jagan

Why do we have the Aggr function as a first argument here?

Re: List box restriction

Wed, 21 Jan 2015 06:06:12 GMT

Hi Jagan

thanks for your help~

one more question~ can i use this expression to restrict the list with the value of another field? such as show the provinces which belongs to China and UK, and there are two fields: province and country.

thanks in advance!

br,

lisen

Re: List box restriction

jagan — Wed, 21 Jan 2015 06:07:13 GMT

Hi Robert,

We can also do the same without using aggr() like below, sometimes we will get issues without aggr() that is why I mentioned Aggr(). Aggr() is something like a loop.

=If(PREF_NAME LIKE 'S*', PREF_NAME)

Regards,

Jagan.

Re: List box restriction

ashfaq_haseeb — Wed, 21 Jan 2015 06:07:37 GMT

You can event try other way around

=If(Name LIKE 'L*',Aggr(Name, Name))

Regards

ASHFAQ

Re: List box restriction

jagan — Wed, 21 Jan 2015 06:52:19 GMT

Hi,

Try like this

=If((Country = 'UK' OR Country='China'), Province)

Regards,

Jagan.

Re: List box restriction

MarcoWedel — Wed, 21 Jan 2015 17:21:40 GMT

or maybe

Aggr(Only({$<name={"L*"}>} name), name)

regards

Marco