topic Re: List Box in QlikView

List Box

upaliwije — Sun, 07 Sep 2014 09:18:25 GMT

Hi Friends

I have following List Box

Dept

Bran

City

Region

In the above list box I want to hide Dept and Region in one of my sheet and display only

Bran

City in my list box.

Pls tell me how I can do it

Re: List Box

IAMDV — Sun, 07 Sep 2014 09:25:25 GMT

You can write the expression in the List Box as show below:

=IF(ListBox= 'Bran' OR Name = 'City', ListBox)

Cheers,

www.QlikShare.com

Re: List Box

ecolomer — Sun, 07 Sep 2014 09:28:33 GMT

Put in Box List an expresion with:

=if(not Match(Var,'Dept','Region'),Var)

Re: List Box

upaliwije — Sun, 07 Sep 2014 09:39:08 GMT

Thanks both

But none of the the methods work. If you can pls upload a sample QV document

Re: List Box

israrkhan — Sun, 07 Sep 2014 09:47:18 GMT

what is your field name, which has these values?

or can you show share a sample doc or screen shots, what you have done...?

but this expression works for me..

=if(FiledName = 'Bran' or FieldName = 'City', FieldName, Null)..

put your field name in the expression....

Hope it helps...

Re: Re: List Box

IAMDV — Sun, 07 Sep 2014 09:47:19 GMT

Really!? that's very strange. Anyway, here is the attachment. See the second Listbox which contains only A & B.

I hope this helps!

Cheers,

Re: List Box

upaliwije — Sun, 07 Sep 2014 10:10:51 GMT

Thanks All

Re: List Box

PrashantSangle — Sun, 07 Sep 2014 10:16:21 GMT

Hi,

Is the

Dept

Bran

City

Region

are values of one List box or they are different list boxes??

If they are values of one List Box then

You have to create List Box With expression like

If(not wildmatch(Fieldname,'*Dept*','*Region*'),FieldName).

Regards,

Re: List Box

MarcoWedel — Sun, 07 Sep 2014 10:47:09 GMT

Hi,

another one:

=Aggr(Only({1-<Type={'Dept','Region'}>} Type), Type)

hope this helps

regards

Marco