topic Circular Reference in QlikView

Circular Reference

Fri, 21 Aug 2015 08:38:04 GMT

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

Re: Circular Reference

jagan — Fri, 21 Aug 2015 08:50:40 GMT

Hi,

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

Regards

Jagan.

Re: Circular Reference

Fri, 21 Aug 2015 09:15:00 GMT

How do i get the Location which is in the TeamList

Re: Circular Reference

manojkulkarni — Fri, 21 Aug 2015 09:20:59 GMT

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

Re: Circular Reference

jagan — Fri, 21 Aug 2015 09:27:30 GMT

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.

Re: Circular Reference

qlikviewwizard — Fri, 21 Aug 2015 13:29:36 GMT

Hi Senthil,

Can you attach the sample data?