Circular Link Issue - Qlik Community

Report Inappropriate Content · ‎2015-12-04

Hi Team,

I am sharing you my sample table structure ( not actual but only sufficient information) to describe my problem and requirement.

The Yellow table is recently added into the application. which have YEAR-MONTH, MEMBERID, CITY wise Cumulative Growth.

due to CITY i am getting Circular Reference. but if i remove the Reference by changing the name i am not able to get link city.

how can i get below mention Information by SET Analysis or any other way.

Thanks in Advance

JKV

marcus_sommer · ‎2015-12-04

There are two possibilities. One is to merge these table with the other tables and the second is to create a bridge-table. I think this will help you: Get started with developing qlik datamodels

- Marcus

vikasmahajan · ‎2015-12-04

just remove city from cumulative client and check

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2015-12-04

Hi.

Not possible then how can i get citywise information then will show MEM_MONTH_KEY wise only .

marcus_sommer · ‎2015-12-04

If I look a second time on your screenshot I think it would be worth to try to get your results without these cummulative table and simply sum and count within the charts.

- Marcus

Report Inappropriate Content · ‎2015-12-04

Hi ,

Not possible, because i did not load whole Client Master (CLIENT TABLE) because its big in size. i load using Exisit() and only those who are present in TRADE TABLE. if i do then it will only count those are present in trade table the Client who register but did not trade that goes miss from here.

and second table Cumulative City Client i Keep Count separately .

if i load the full Client Master (CLIENT TABLE) then i can easily do.

Can this possible to compare two fields in set Analysis?

jonathandienst · ‎2015-12-04

Are you trying to count active clients (exist in trade table and have actually traded) or all clients (exist in client table and may not have traded)?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

vikasmahajan · ‎2015-12-04

concatenate or use joins for both client tables

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2015-12-04

Hi,

you are right jonathan. i want to count all Clients, whether they traded or not traded did not matter.

Report Inappropriate Content · ‎2015-12-04

Hi.

I think that is not good to do because both are different in dimension. Client is pure Master table where Cumulative Client is Fact Table.

also the cumulative value is Month city Member wise