https://community.qlik.com/t5/QlikView/Issue-with-joining-2-fact-tables/m-p/374088#M139212 <HTML><HEAD></HEAD><BODY><P>I have essentially 2 fact tables</P><P></P><P>A fact table for my Materials which contains Material, Volume in Stock (VoS) and Material Price</P><P></P><P>And also a Customer fact table which contains Customer, Volume Sold and Value Sold</P><P></P><P>I need to create a pivot table displaying Material, VoS, Volume Sold and Value Sold</P><P></P><P>I left join the customer table to the material table - and then load the fields into a qvd - then load the qvd in my scrpit and drop the original material/customer table</P><P></P><P>My issue is that the VoS figure is being multiplied by the Volume Sold figure when I load the customer fact table into my script</P><P></P><P>When I exclude the customer fact table the VoS figure is correct, however when I include the customer table the VoS figure increases dramatically.</P><P></P><P>Hopefully this makes sense</P><P></P><P>Thanks</P></BODY></HTML> Mon, 30 Jul 2012 10:28:53 GMT 2012-07-30T10:28:53Z https://community.qlik.com/t5/QlikView/Issue-with-joining-2-fact-tables/m-p/374088#M139212 <HTML><HEAD></HEAD><BODY><P>I have essentially 2 fact tables</P><P></P><P>A fact table for my Materials which contains Material, Volume in Stock (VoS) and Material Price</P><P></P><P>And also a Customer fact table which contains Customer, Volume Sold and Value Sold</P><P></P><P>I need to create a pivot table displaying Material, VoS, Volume Sold and Value Sold</P><P></P><P>I left join the customer table to the material table - and then load the fields into a qvd - then load the qvd in my scrpit and drop the original material/customer table</P><P></P><P>My issue is that the VoS figure is being multiplied by the Volume Sold figure when I load the customer fact table into my script</P><P></P><P>When I exclude the customer fact table the VoS figure is correct, however when I include the customer table the VoS figure increases dramatically.</P><P></P><P>Hopefully this makes sense</P><P></P><P>Thanks</P></BODY></HTML> Mon, 30 Jul 2012 10:28:53 GMT https://community.qlik.com/t5/QlikView/Issue-with-joining-2-fact-tables/m-p/374088#M139212 2012-07-30T10:28:53Z