Qlik Community

Ask a Question

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY

Real Loosen Tables

simonaubert
Partner
Partner

Real Loosen Tables

Hello all,

I work on a project where I try to offer to the user an access to some dozens of table. Of course, in order to prevent bad joining or lnking, I have to break the relation between tables. I have, as far know, two options for that  : qualify or loosen table. If you're not familiar with it : a loosen table is a table without any link to the other table.
https://help.qlik.com/fr-FR/sense/November2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

So, let's test :

TABLEA:
LOAD * Inline
[FIELD_A, FIELD_B, FIELD_C
VALUEA1,VALUEB1,100
VALUEA2,VALUEB2,200]
;

loosen table TABLEA;
NoConcatenate
TABLEB:
LOAD * Inline
[FIELD_A, FIELD_D, FIELD_C
VALUEA1,VALUEB1,100
VALUEA3,VALUEB2,200]
;
loosen table TABLEB;

 

Result :

image.png

Sounds cool, let's go further and build a table :
image.png

Sooooooo, basically, next step, I should only show the value in TableA.
Wait for it....

simonaubert_0-1611173337340.png


Really ? Why do I have the value 3?

Well, let's have an aggregation now :

simonaubert_2-1611173565848.png

Ok, this time, it's what I expected.

I will now make this game a little harder  : what if the two tales have the exact same field name?

TABLEA:
LOAD * Inline
[FIELD_A, FIELD_B, FIELD_C
VALUEA1,VALUEB1,100
VALUEA2,VALUEB2,200]
;

loosen table TABLEA;
NoConcatenate
TABLEB:
LOAD * Inline
[FIELD_A, FIELD_B, FIELD_C
VALUEA1,VALUEB1,100
VALUEA3,VALUEB2,200]
;
loosen table TABLEB;

 

simonaubert_3-1611173710431.png

Same result :

simonaubert_5-1611173839322.png

 



And finally... what if I want the value of TableB ?

simonaubert_6-1611173925898.png

simonaubert_7-1611173988946.png

I' m unable to query the second table...

But I may have misunderstood loosen for lost 🤡

Well, finally, the idea is simply to have a naturel management of loosen table, a real independancy and the ability to query all the data.

image.png

(sorry for the meme, it's my way to relax)
Best regards,

Simon

Bi Consultant (Dataviz & Dataprep) @ Business & Decision
3 Comments
Meghann_MacDonald

This looks like a tough one! 

simonaubert
Partner
Partner

@Meghann_MacDonald  Probably not the easiest idea I posted but the behaviour today... who does understand the logic and use it?

At Tableau, for the new "relation" feature, they add a layer of modelisation, I guess something like that would make it for the loosen table?


Olivier_W
Partner
Partner

I agree Meghann