Qlik Community

Ask a Question

Suggest an Idea

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

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW

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