Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sudhakar_budde
Creator
Creator

Circular Joins (3 Tables joining each other on the same key)

Hi,

I have 3 tables joining on the same key. Is this normal?

I am thinking this is a circular join.How can I resolve this? Please see attached table viewer screenshot.

Thanks in advance for your suggestions.

SB

1 Solution

Accepted Solutions
datanibbler
Champion
Champion

Hi sudhakar,

no - at least, what is seen on that screenshot, that is not a circular JOIN, that is quite ok - QlikView would issue a warning if you had a circular reference - you run that risk only if you have several different keys that join A to B, B to C and C to A, not if all three tables share the same key.

Best regards,

DataNibbler

View solution in original post

6 Replies
datanibbler
Champion
Champion

Hi sudhakar,

no - at least, what is seen on that screenshot, that is not a circular JOIN, that is quite ok - QlikView would issue a warning if you had a circular reference - you run that risk only if you have several different keys that join A to B, B to C and C to A, not if all three tables share the same key.

Best regards,

DataNibbler

balkumarchandel
Specialist II
Specialist II

Sudhakar,

Joining with singleKey for multiple table is not circular reference. Its ok with QV.

See below link by HIC. you will be clear on circular reference.

Circular References

Thanks

BKC

sasiparupudi1
Master III
Master III

It is not a circular reference issue and your join looks fine

sudhakar_budde
Creator
Creator
Author

Hi Sasidhar,

Thanks for your reply.

sudhakar_budde
Creator
Creator
Author

Hi Balkumar,

Thanks for your reply.

Regards

SB

sudhakar_budde
Creator
Creator
Author

Hi,

Thanks for your reply.

SB