topic Auto Select Fields in List Box based on a selection in QlikView

Auto Select Fields in List Box based on a selection

Anonymous — Mon, 09 Jan 2017 17:12:09 GMT

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

Re: Auto Select Fields in List Box based on a selection

girirajsinh — Mon, 09 Jan 2017 17:26:01 GMT

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

Re: Auto Select Fields in List Box based on a selection

johnw — Tue, 10 Jan 2017 01:30:25 GMT

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.