Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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 II
Champion II

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

vinieme12
Champion II
Champion II

vinieme12
Champion II
Champion II

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