Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Creator II
Creator II

Circular loop

Hello All,

Request you to please help me with below scenario :-

I have below tables :-

Table A:

Load

%Id card,

%project ID

From ...

----------------------------

Table B:

Load

%userid,

%project ID

From ......

---------------------------------------------

Table C:

Load

%userid

NBhours 

From .....

-------------------------------------------------

Table D 

Load 

team_workload,

user id as  %userid,

id card as %id card

from............

=================================

My requirement is to establish below relationship:-

Table B with Table D on %userid

Table C with table D on %project id

Right now when i do this it created circular loop . And i cannot rename any field in Table D as it hampers my records. 

Can we do this by creating any key ,not sure, can anyone please help ?

 

Thanks in advance

1 Reply
rubenmarin

Hi, I would need to know more about what data stores each table, wich what I see in the sample I would do a Join between A and D tables, then add table B to the join.

If needed, you can oly join the key fields, and from the joined table you can create combined keys to relate to the facts of tables A, B or D

Table C is not an issue as it ony has one key so it can be also joined or stay as independent table... if joining with the alredy joined table creates duplicates of data, it will be better to keep as independent table.