Conditional show of listboxes

[Anonymous]

Hi!

I have a list box with a 500+ values that I would like to separate into "sub-listboxes" with predefined values in each. For example i want sub-listbox1 to contain values A, C and D, sub-listbox2 to contain values M,K,L,B and A and so on.

I Think that the easiest way is to make copies of the same listboxes with different conditional-show expressions but I can't make it work. I tried =if(field='A' or field='C', field) but it didn't work since the other field are still visible, and choosable.

Thankful for any kind of help!

/Charlotte

[sunny_talwar]

I think instead of conditional show, you should use list box with expressions. There is two way to write the expression

1) If(Match(field, 'A', 'C', 'D'), field)

or

2) Aggr(Only({1<field = {'A', 'C', 'D'} field), field)

[Anonymous]

Thank you! I tried both the expressions, but unfortunatley my other field values are still choosable. I only want to see A, C and D.

[Anonymous · Accepted solution]

Listbox > properties >

Under field, scroll right down and select <Expression>

the expression editior will pop up

add this expression

if(WildMatch(PRODUCT,'A*','B*','C*'),PRODUCT)

Title: Products A to C

Repeat for each subset...

[its_anandrjs]

Check this attached Qlik file

Use this expression:- =IF(Match(Product,'A','C','D'),Product)

Regards

Anand

[Anonymous]

Many thanks!!!!!

[Anonymous]

thank you all for your help! I now solved it