How does Qlik auto define which table to use for a field?

Anonymous — Wed, 31 Jan 2018 15:06:23 GMT

Hello all,

possibly silly question here, however hopefully will make sense. If i have a table with 500 or so records, all with a uniqueID field

example:

Data:

UniqueID	Q1	Q2	Q3
1	Yes	Red	15
2	Yes	Red	16
3	No	Blue	18
4	Yes	Green	19

and I then have an offshoot table which uses the UniqueID to pull through the answers to each seperate question, and a description, for example:

Offshoot:

Load UniqueID as UniqueID,

Q1 as Question

'Description' as Description

resident data;

concatenate(Offshoot)

Load UniqueID as UniqueID,

Q2 as Question

'Description' as Description

resident data;

etc.

I then have 500 unique ID's but in this offshoot table I will have 1500 of rows in the Offshoot table.

When I go into sheets and do a simple KPI it recognises count(UniqueID) as 500 - and same with distinct before - I am just wondering how Qlik automatically picks which table a joining field comes from (in this case the data table, not the offshoot), whether there is science behind you pick the bigger table or what Qlik perceives as the source table, or whether it is dependant on what other visualisations are present?

I have since fixed the join by doing a duplicate of the uniqueID as something else, then joining on that field, but just curious as to how the engine works?

topic How does Qlik auto define which table to use for a field? in App Development

How does Qlik auto define which table to use for a field?