2 Replies Latest reply: Feb 16, 2018 5:50 AM by Massimo Favaro RSS

    Many to many relationship with automatic data loading

    Massimo Favaro

      Hello everyone.

      I have not a precise question, I just wanted to have some clarifications about how Qlik Sense works.

      I have used several Business Intelligence apps but a "many to many" relationship has always been impossible to do because atleast one table mustn't have duplicated values.

       

      This is the case I am working on:

      Screenshot_2.png

      I have not used a custom script and account_id presents duplicated values both in transactions and users.

      How does Qlik Sense works in this case?
      Does it performs something like a full outer join between Transactions and Users, and an inner join between this table and User Details?