Disabling QlikSense Auto Join feature

[Naushad07]

Hi All,

I have 2 tables. Let's call them A and B. All of these tables are Mutually Exclusive with the same set of metrics. Let the Metrics be M and N.

This is my Load Script:

[Table A]:

Dimension 1,

Dimension 2,

Metric M,

Metric N

[Table B]:

Dimension 3,

Metric M,

Metric N

As you can Observe here, Qliksense will join them automatically. But these are 2 different sets of data that I am fetching from different sources. How do I load without Join or Concatenate?

[vunguyenq89 · Accepted solution]

Qlik Sense creates an association for any pairs of fields in 2 tables that have the same name. You can prevent this automatic association by aliasing the fields (LOAD [Metric M] AS [Metric M1]... for example).

You can also use Qualify command to prefix filed names with table names, see https://help.qlik.com/sv-SE/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS...

Hope this helps,

BR,

Vu Nguyen