topic Disabling QlikSense Auto Join feature in App Development

Disabling QlikSense Auto Join feature

Naushad07 — Sat, 16 Nov 2024 04:08:38 GMT

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?

Re: Disabling QlikSense Auto Join feature

vunguyenq89 — Tue, 12 Nov 2019 08:01:35 GMT

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/ScriptRegularStatements/Qualify.htm

Hope this helps,

BR,

Vu Nguyen