Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Auto Select Fields in List Box based on a selection

I have data in below format in a list box .If I select 'A&B' field it should auto select A as well.If I select field value 'C&D' it should select 'C' as well .

column
A
A&B
C&D
D

Please help me with logic

2 Replies
girirajsinh
Creator III
Creator III

Hi Krishna

Try this,

and surely you can make it more dynamic by using strings and conditional functions. This is just to give you some direction.

expression for search string should be

johnw
Champion III
Champion III

Not exactly what you asked for, but I'd probably handle this in the data model with a new table and field:

column selector,column
A,A
A&B,A
A&B,A&B
C&D,C&D
C&D,D
D,D

Just make a list box for column selector with a legend of column, and it will "select" the desired values of column.