Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Circular Reference

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

Tags (1)
5 Replies
MVP & Luminary
MVP & Luminary

Re: Circular Reference

Hi,

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

Regards

Jagan.

Not applicable

Re: Circular Reference

How do i get the Location which is in the TeamList

Partner
Partner

Re: Circular Reference

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

MVP & Luminary
MVP & Luminary

Re: Circular Reference

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
Honored Contributor II

Re: Circular Reference

Hi Senthil,

Can you attach the sample data?