Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
huixuan_tan
Contributor II
Contributor II

difficult to join with necessary duplicate values

Hi

I am stuck with this data set tables

Student info:

Admin NumberNameYear of study
20001Sally2
20002Tom3
20003Ashley1
20004Bernard2
20005Travis2

 

Event info:

AttendanceEvent IDEvent Name
20001course002Heartbeat
20003course002Heartbeat
20001elective001Spartan
20005elective001Spartan
20003elective001Spartan
20004music004Violin
20002music004Violin
20001music004Violin

 

My goal:  identify students who did not attend each activity by their admin number.

Issue: Duplicate admin number in attendance = cannot use join

Note: no hard coding allowed eg. wildmatch because there may be new programmes created in the future.

Please help:-) thank you so much:)

3 Replies
Lisa_P
Employee
Employee

Can you rename Attendance to [Admin Number] in the script ? This will associate these fields and give your results.

huixuan_tan
Contributor II
Contributor II
Author

The attendance data has multiple programmes so a join wouldn’t do as there are duplicate admin numbers  but only 1 student info table 

qlikerB96
Contributor III
Contributor III

Hi,

Would you like to solve this problem in the script or in the visualization?

What Lisa_P said could be a correct way. If you give same names to two fields Qlik will make connection without any join. After this if you make two table charts (like in your post) and you pick a student you will see all the Events.

But if I understood well your post, you would like to have for example a new filed with a value 'OK', 'NOT OK' for each student and this value will depend on the attended events?

B.