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: 
Not applicable

Auto select values in other fields of a table based on selection of an ID

I have a table as follows:

 

IdCourse1Course2Course3Course4Course5
1ABC
2EFGHI
3J
4KLM
5NO
6P
7QRSTU
8VW
9X
10YZ

I have created list boxes Id, Course1, Course2, Course3, Course4, Course5. Now, when I select Id as 1 in the listbox Id, I want A in listbox Cousre1, B in listbox Course2 and C in listbox Course3 to be selected (background of selection in green) automatically. Tried fieldindex function, but did not work. Similarly when I select Id as 2, I need E, F, G, H, I values to be selected (i.e.) the corresponding course values.

Any help would be appreciated!

Thanks!

3 Replies
vinieme12
Champion III
Champion III

There is no need to select the corresponding  values separately as you are making selections on the rowkey

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

Read these

Logical Inference and Aggregations

Why is it called Set Analysis?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

if you still want to enforce a selection then

create  listbox with Expression

=aggr(only({1}Id),Course1,Course2,Course3,Course4,Course5)

see attached app ! Make selections on ID field and try for yourself

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.