Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
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

6 Replies
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

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

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

sudhakar_budde
Contributor

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

Hi Sasidhar,

Thanks for your reply.

sudhakar_budde
Contributor

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

Hi Balkumar,

Thanks for your reply.

Regards

SB

sudhakar_budde
Contributor

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

Hi,

Thanks for your reply.

SB

Community Browser