Discussion board where members can get started with Qlik Sense.
I have a question about the relationship between tables.
I have uploaded two tables:
and the relationship between these two tables should be "Full Outer Join", right?My question is: is it possible to change this relationship to inner join?
I know I can join these two tables in the script but I'd prefere to keep the tables divided
(i joined them with this script:
SQL SELECT "id",
Go to Solution.
no, you cannot specify the inner/outer-ness of the logical connection between tables in your data model.
What is the end goal?
You may be able to "filter" out rows by looking at missing values in the other table.
if([user detail].somefield is null,'',[user id].datapoint)
and the relationship between these two tables should be "Full Outer Join", right?
Joins are used to join tables so the result is one table. A Full Outer Join is not a relationship but an operation.
My question is: is it possible to change this relationship to inner join?
An inner join is also an operation, not a relation.
Then load the tables separately and don't join them.