MProgram.ID maps to MProgramParticipant.ProgramCenterID
MParticipant.ParticipantID maps to MProgramParticipant.ParticipantID
MProgram has 2242 entries
MParticipant has 23032 entries
MProgramParticipant has 24603 entries. However, because it is mapping Program to participant id, it has multiple entries for both Program and Participant because each program is attended by multiple participants
I removed the duplicates and found that it has entries for 848 Unique Programs and 5084 Participants. I want to display this count on my dashboard as a metrics saying out of 23032 participants, only 5084 were covered as part of 848 programs.
Now, when i am loading this to Qlik Sense, MProgramParticipant.ParticipantID is associating with MParticipant.ParticipantID. Association name is ParticipantID.
When I am trying to display Count(distinct [ParticipantID]) it always shows the merge count of Participants 23032. Any suggestions?