How to eliminate Circular reference in data model - Qlik Community

Aditya_Chitale · ‎2021-09-06

Hi All,

I want to eliminate circular reference in my data model without creating a duplicate table and renaming the fields.

This is a demonstration of my data model. Here I have taken Campaign id as filter in my sheet and on campaign id selection, I want to show project wise Amount from Link Table. For eg. Campaign id '123' has Project name 'XYZ' so I want to show XYZ's sum of Amount on Campaign 123's selection.

Kindly provide a solution to this issue.

Regards,

Aditya

vikasmahajan · ‎2021-09-07

Rename project name from Campaign table as project name_1

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.

AshutoshBhumkar · ‎2021-09-07

Hi,

If the Project Name column coming from both the table and have different values then rename them as per their meaning.

i.e You can rename the Project Name from the Campaign table as [Campaign Project Name]

Aditya_Chitale · ‎2021-09-07

Hi Ashutosh,

Field from both tables have same meaning

Regards,

Aditya

vikasmahajan · ‎2021-09-07

Qlik is working on associative technology the project name is a common and forming loop into your data hence you can rename it or remove it if no longer required.

source :https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/LoadData/understand-ci...

refer Henric Post : https://community.qlik.com/t5/Qlik-Design-Blog/Circular-References/ba-p/1469332

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.