Discussion Board for collaboration on QlikView Layout & Visualizations.
in the Table viewer , considering 3 Tables
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
Comment the QA_BankID column in the QA table and check whether the values are matching.
How do i get the Location which is in the TeamList
If you elaborate more on your data model, it will be more helpful to understand & suggest the linking of tables
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.
Can you attach the sample data?