Suggest an Idea

[simonaubert]

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 :



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


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

Really ? Why do I have the value 3?

Well, let's have an aggregation now :

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;

Same result :

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

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.



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

Simon

[Meghann_MacDonald]

This looks like a tough one! 

[simonaubert]

@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]

I agree Meghann

[fbar]

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]

@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.