Discussion board where members can get started with Qlik Sense.
I have two tables.
When I select 'class1' field from Table1, the duration values of a, d and x should be selected via 'comp' field from Table2.
When I select 'class2' field from Table1, the duration values of b, e and y should be selected via 'comp' field from Table2.
The same things for other fields...
How can I join these tables ?
Thanks for kind reply in advance.
You would want to use the CROSSTABLE function: https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/LoadData/work-with-cross-tables.h...
Your script should look something like this:
Load Class, Student
Load Comp, Duration
Thanks for your help Serina.