Skip to main content

Suggest an Idea

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

Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Real Loosen Tables

simonaubert
Partner - Specialist II
Partner - Specialist II

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
8 Comments
Meghann_MacDonald

This looks like a tough one! 

simonaubert
Partner - Specialist II
Partner - Specialist II

@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 - Contributor III
Partner - Contributor III

I agree Meghann

Ian_Crosland
Employee
Employee
 
Status changed to: Open - Collecting Feedback
fbar
Contributor
Contributor

Your solution is basically what Qualify does, right?

 

But I too would like to have Joins like in SQL.
Right now, Tables are joined by Fieldnames.

But SQL Joins are MUCH better.

simonaubert
Partner - Specialist II
Partner - Specialist II

@fbar  Hello. More than a solution, it's an idea request (and you can vote for 😉  ). qualify would add a prefix to the field name and I don't want that prefix.

Best regards,

Simon

Meghann_MacDonald

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived