Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
sudhakar_budde
Contributor

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
datanibbler
Esteemed Contributor

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

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
Highlighted
datanibbler
Esteemed Contributor

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

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

Highlighted
balkumarchandel
Valued Contributor II

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

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

Highlighted
sasiparupudi1
Honored Contributor III

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

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

Highlighted
sudhakar_budde
Contributor

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

Hi Sasidhar,

Thanks for your reply.

Highlighted
sudhakar_budde
Contributor

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

Hi Balkumar,

Thanks for your reply.

Regards

SB

Highlighted
sudhakar_budde
Contributor

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

Hi,

Thanks for your reply.

SB