topic Re: Connecting Data Circle-wise in Connectivity & Data Prep

Connecting Data Circle-wise

schuffe — Mon, 14 Dec 2020 11:50:30 GMT

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 ?

Re: Connecting Data Circle-wise

martinpohl — Mon, 14 Dec 2020 14:25:22 GMT

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

Re: Connecting Data Circle-wise

schuffe — Tue, 15 Dec 2020 11:29:54 GMT

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.

Re: Connecting Data Circle-wise

schuffe — Tue, 15 Dec 2020 12:02:52 GMT

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 ^^