topic Re: Conditional show of listboxes in QlikView

Conditional show of listboxes

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Conditional show of listboxes

sunny_talwar — Tue, 15 Nov 2016 13:15:23 GMT

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)

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

Re: Conditional show of listboxes

Anonymous — Tue, 15 Nov 2016 13:20:42 GMT

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.

Re: Conditional show of listboxes

Anonymous — Tue, 15 Nov 2016 13:21:06 GMT

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

Re: Conditional show of listboxes

its_anandrjs — Tue, 15 Nov 2016 13:26:23 GMT

Check this attached Qlik file

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

Regards

Anand

Re: Conditional show of listboxes

Anonymous — Tue, 15 Nov 2016 13:28:04 GMT

Many thanks!!!!!

Re: Conditional show of listboxes

Anonymous — Tue, 15 Nov 2016 13:28:23 GMT

thank you all for your help! I now solved it