Problem circular reference

[#1]

Hey everybody, im amateur here in qlikview and i have a problem with this circular references

How does it works

Thanks

[er_mohit]

Hii i think you have to change the name of Articulo_ID as Articulo_id in stock table

Because circular refrence occur when three tables are joined toghether so to remove you have to use alias means change the name

or if you want to join that table into other table then use before load that table write join (tablename) Doing this, you don't want to change the fieldname

hope it helps

[#3]

but if i change that name, qlikview will also internally matches me stock with my articule?

(and its the same if i put qualify instead changing the name in that case?)

[er_mohit]

Yeah if you put qualify Articulo_ID;

then it alias your field with Stoke.Articulo_ID