Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
kishorj1982
Creator II
Creator II

selection in the list box based on selection in the other

Hi

I have a list box where values are

111111

222222

333333

I have another list box with values

1111

2222

3333

How to select values automatically in the second list box based on selection of first? i.e. if in first list box I am selecting 111111 then in the second list box 1111 should be selected

5 Replies
oknotsen
Master III
Master III

Connect the fields in your data model. For example by adding an InLine table like this:

ExampleTabel:
LOAD * INLINE [
FieldA, FieldB
1111, 111111
2222, 222222
3333, 333333
]
;

May you live in interesting times!
kishorj1982
Creator II
Creator II
Author

No thats not the way - I caanot join these fields -

Let me clear -

1st List box -

111111

222222

second list box

1110

1111

1112

2220

2222

2223

when I ll select 111111 in first list box,  1111 in the second list box should be selected.

and when 222222 then 2222 only

Please suggest

MarcoWedel

Dealing with this requirement in the script/data model being the better choice, an alternative could be to use "on select" triggers and "select in field" actions.

hope this helps

regards

Marco

kishorj1982
Creator II
Creator II
Author

Thanks Marco -

Basically, in order to change it in the Data model, what we need to do ?

NareshGuntur
Partner - Specialist
Partner - Specialist

This seems to be a dummy data what you are showing here.

How do you identify the relation between 111111 and 1111?

Cheers,

Naresh