Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Many to many relationship with automatic data loading

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?

1 Solution

Accepted Solutions
Partner
Partner

The relations between all the tables are full outer join.

View solution in original post

2 Replies
Partner
Partner

The relations between all the tables are full outer join.

View solution in original post

Contributor III
Contributor III

Ah.

Now I understand why I can't find two "id" columns and two "account_id".

Many thanks.

I guess it's always best practice to use a custom loading script therefore...