Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
schuffe
Contributor III
Contributor III

Connecting Data Circle-wise

Hello everyone, I know that you normally dont make such circular-references like you see here:

Unbenannt1.PNG

But i need to make one of these.

If I want to connect my data like you see in the picture, the Tables are connected like this:

Unbenannt3.PNG

And i get a "synthetic key". Anybody knows, how to connect the Data in a circle ?

 

3 Replies
martinpohl
Partner - Master
Partner - Master

in Qlik Sense this doesn't work.

If there is a circular reference, Qlik will cut one link between tables to show available datas.

In Qlik, don't think in SQL, think in QIX!

Regards

schuffe
Contributor III
Contributor III
Author

At first: Thank You for the answer, that is good to know, but my problem is still unsolved :).

So let me explain my intention, maybe you, or someone else can help. I dont think that this is a very difficult one, but i am not able to build it how I want it to be. I prepared some Data to explain it:

I have 3 tables A,B and C and they are build like this :

A: Date | Person | Profit

B: Date | Person | Profit Planned

C: Person | Group

And I want them to be connected like this :

Unbenannt.PNG

I want to show the profit and profit planned in my app and I want to use those 3 Filters:

1. Date  2. Person 3. Group

 

Now I know, that I cant make this circular reference, but how do I do it then? Probably its very simple, but I dont know how to solve it.

schuffe
Contributor III
Contributor III
Author

Okay, I did it by myself 😛

If someone has the same question i can write how i did it, if not i would say this post is solved ^^