Circular Reference

[#1]

Hi All

in the Table viewer , considering 3 Tables

1. QA

2. TeamList

3. New

QA Table is linked with New Table based on a common key named as Key_QA. (Key_QA is the combination of Month and Platform)

TeamList is linked with QA and New Table based on QA_BankID and BankID. (To Avoid synthetic i have renamed BankID as QA_BankID)

But it creates a circular reference. How do i avoid it

[jagan]

Hi,

Comment the QA_BankID column in the QA table and check whether the values are matching.

Regards

Jagan.

[#3]

How do i get the Location which is in the TeamList

[manojkulkarni]

If you elaborate more on your data model, it will be more helpful to understand & suggest the linking of tables

[jagan]

Already there is a link between Team & New tables using the BankID so you will get the locations.

You have to break the relation between any of this tables TeamList, New & QA, then only this is resolved. Based on the business requirement break the relation by renaming any key column names.

Hope this helps you.

Regards,

Jagan.

[qlikviewwizard]

Hi Senthil,

Can you attach the sample data?