topic avoiding circular reference with mandatory connection in QlikView https://community.qlik.com/t5/QlikView/avoiding-circular-reference-with-mandatory-connection/m-p/1223373#M871924 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have got two tables, they are really similar, one represent the consumption of A with his attributes, not very different from the consumption of B, but A and B cannot become the same table.</P><P>A and B have in common 2 tables (groups and Products) with all their personal details.</P><P>I' d like to make a pivot table with element of Groups and Products,so it's correct to use them as the link between A and B and I cannot unify Groups and Products because they are totally different.</P><P>I want to avoid the circular reference, but I cant understand how.</P><P></P><P>Can you help me?</P><P>Ciao</P><P>Amos</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z avoiding circular reference with mandatory connection https://community.qlik.com/t5/QlikView/avoiding-circular-reference-with-mandatory-connection/m-p/1223373#M871924 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have got two tables, they are really similar, one represent the consumption of A with his attributes, not very different from the consumption of B, but A and B cannot become the same table.</P><P>A and B have in common 2 tables (groups and Products) with all their personal details.</P><P>I' d like to make a pivot table with element of Groups and Products,so it's correct to use them as the link between A and B and I cannot unify Groups and Products because they are totally different.</P><P>I want to avoid the circular reference, but I cant understand how.</P><P></P><P>Can you help me?</P><P>Ciao</P><P>Amos</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/avoiding-circular-reference-with-mandatory-connection/m-p/1223373#M871924 2020-11-25T16:16:04Z