List Box

[upaliwije]

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

[IAMDV]

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

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

Cheers,

DV

www.QlikShare.com

[ecolomer]

Put in Box List an expresion with:

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

[upaliwije]

Thanks both

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

[israrkhan]

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...

[IAMDV · Accepted solution]

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

I hope this helps!

Cheers,

DV

[upaliwije]

Thanks All

[PrashantSangle]

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,

[MarcoWedel]

Hi,

another one:

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

hope this helps

regards

Marco