Qlik Community

Qlik Sense App Development

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

agarciaguillen
New Contributor II

Relation between 3 dimentions problem

Hi everyone,

                    I have a problem when i try to create a relation between two dimensions because one of these was related with other dimension and that create a "Circular Reference".

This is my first time  with the tool and i really don´t know how to solve it.

Context :


I try to relate Destinatarios table with Zona table but Clientes table is related with Zona before. (Image 1)

Image 1.PNG

When i create a filed in the table Zona for relate this table with Destinatarios, the pogram create a Circular reference. (Imagen 2)

Image 2.PNG

Note: I only use the table Zone to obtain geographical information.

I imagined  a posible solution :

I think create a other table Zona with other name to masking the problem calling the same table twice, but i thinks its some dirty and waste resources.

Thanks in advance.

1 Solution

Accepted Solutions
dwforest
Valued Contributor

Re: Relation between 3 dimentions problem

your imagined solution is correct.

another would be to join the zona table to destinatarios if only a few fields are needed, just be sure the names added are unique

Qlik manages the duplicate data very well

2 Replies
dwforest
Valued Contributor

Re: Relation between 3 dimentions problem

your imagined solution is correct.

another would be to join the zona table to destinatarios if only a few fields are needed, just be sure the names added are unique

Qlik manages the duplicate data very well

agarciaguillen
New Contributor II

Re: Relation between 3 dimentions problem

Really thanks, You reply is very useful to me .