topic Link Table Multiplication in QlikView https://community.qlik.com/t5/QlikView/Link-Table-Multiplication/m-p/379269#M702743 <HTML><HEAD></HEAD><BODY><P>We have 2 tables connected by a link table.&nbsp; This link table conencts many tables together in the data model.&nbsp; The problem is that if I multiply a single key in one table by a single keyed value in another table, my result is then further multiplied by the number of total keys of that combination in the link table.</P><P></P><P>Please open my app and take a look at what I mean (heavily simplified for example sake).</P><P></P><P>I am looking to achieve an answer of 16 (2x8) but because there is a third key in the link table that duplicates the other two keys, I end up with an incorrect answer of 32.</P><P></P><P>I have used link tables for a long time and never realized this until now.&nbsp; What am I doing wrong???</P></BODY></HTML> Mon, 20 Aug 2012 23:36:02 GMT Anonymous 2012-08-20T23:36:02Z Link Table Multiplication https://community.qlik.com/t5/QlikView/Link-Table-Multiplication/m-p/379269#M702743 <HTML><HEAD></HEAD><BODY><P>We have 2 tables connected by a link table.&nbsp; This link table conencts many tables together in the data model.&nbsp; The problem is that if I multiply a single key in one table by a single keyed value in another table, my result is then further multiplied by the number of total keys of that combination in the link table.</P><P></P><P>Please open my app and take a look at what I mean (heavily simplified for example sake).</P><P></P><P>I am looking to achieve an answer of 16 (2x8) but because there is a third key in the link table that duplicates the other two keys, I end up with an incorrect answer of 32.</P><P></P><P>I have used link tables for a long time and never realized this until now.&nbsp; What am I doing wrong???</P></BODY></HTML> Mon, 20 Aug 2012 23:36:02 GMT https://community.qlik.com/t5/QlikView/Link-Table-Multiplication/m-p/379269#M702743 Anonymous 2012-08-20T23:36:02Z Re: Link Table Multiplication https://community.qlik.com/t5/QlikView/Link-Table-Multiplication/m-p/379270#M702744 <HTML><HEAD></HEAD><BODY><P>I am finding that using the word DISTINCT solves this issue.&nbsp; Not sure if there is data model solution for this kind of issue.&nbsp; I know distinct is expensive expression.</P></BODY></HTML> Tue, 21 Aug 2012 00:20:19 GMT https://community.qlik.com/t5/QlikView/Link-Table-Multiplication/m-p/379270#M702744 Anonymous 2012-08-21T00:20:19Z