topic Joining two resident tables in QlikView https://community.qlik.com/t5/QlikView/Joining-two-resident-tables/m-p/151096#M29010 <HTML><HEAD></HEAD><BODY><P>I have tow tables with information of which I want to multiply a value from table 1 with a value from table 2 and store it in table 3.</P><P>First table</P><P>%ITM , TTYPE, TQTY</P><P>Second table</P><P>DOCO, %ITM, QTY</P><P>I want to multiply QTY with TQTY and store this in a third table</P><P>table 3</P><P>DOCO, SERVICE, SCOST</P><P></P><P>Second.DOCO = DOCO</P><P>first.TTYPE = SERVICE</P><P>TQTY.QTY = SCOST</P><P></P><P>I dont know how to load info from 2 resident tables.</P><P>Who can help me</P><P></P></BODY></HTML> Wed, 05 Aug 2009 20:54:37 GMT 2009-08-05T20:54:37Z Joining two resident tables https://community.qlik.com/t5/QlikView/Joining-two-resident-tables/m-p/151096#M29010 <HTML><HEAD></HEAD><BODY><P>I have tow tables with information of which I want to multiply a value from table 1 with a value from table 2 and store it in table 3.</P><P>First table</P><P>%ITM , TTYPE, TQTY</P><P>Second table</P><P>DOCO, %ITM, QTY</P><P>I want to multiply QTY with TQTY and store this in a third table</P><P>table 3</P><P>DOCO, SERVICE, SCOST</P><P></P><P>Second.DOCO = DOCO</P><P>first.TTYPE = SERVICE</P><P>TQTY.QTY = SCOST</P><P></P><P>I dont know how to load info from 2 resident tables.</P><P>Who can help me</P><P></P></BODY></HTML> Wed, 05 Aug 2009 20:54:37 GMT https://community.qlik.com/t5/QlikView/Joining-two-resident-tables/m-p/151096#M29010 2009-08-05T20:54:37Z