Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone, I know that you normally dont make such circular-references like you see here:
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:
And i get a "synthetic key". Anybody knows, how to connect the Data in a circle ?
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
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 :
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.
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 ^^