7 Replies Latest reply: Aug 26, 2017 12:19 PM by Jonathan Enser RSS

    Associate data table with 2 fields?

    Jonathan Enser

      Hi,

       

      I am new to Qlik Sense and need help from the experts. I have a relatively simple data model with tables that need to be associated by 2 fields (client, teams). Primary keys are of course single fields. My current result is that all of my tables are related by the client field. Works well for client-level analysis, but I'm not able to get the team-level analysis.

       

      I generated the attached diagram to explain what I'm dealing with. One option I noted is to create a concatenated primary key field (client-team). I also came across Qlik documentation that mentioned synthetic keys, but it says that Qlik would automatically generate it if appropriate; that doesn't happen.

       

      Any recommendations? Your help and insight is GREATLY appreciated.

       

      Thank you!!

       

      Jon