topic Re: Auto select values in other fields of a table based on selection of an ID in QlikView

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

Tue, 17 Jan 2017 21:52:27 GMT

I have a table as follows:

Id	Course1	Course2	Course3	Course4	Course5
1	A	B	C
2	E	F	G	H	I
3	J
4	K	L	M
5	N	O
6	P
7	Q	R	S	T	U
8	V	W
9	X
10	Y	Z

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!

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

vinieme12 — Fri, 27 Jan 2017 06:18:50 GMT

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

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

vinieme12 — Fri, 27 Jan 2017 06:20:31 GMT

Read these

Logical Inference and Aggregations

Why is it called Set Analysis?

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

vinieme12 — Fri, 27 Jan 2017 15:45:18 GMT

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