topic Joining 2 resident tables in QlikView https://community.qlik.com/t5/QlikView/Joining-2-resident-tables/m-p/151124#M29038 <HTML><HEAD></HEAD><BODY><P>close</P></BODY></HTML> Wed, 05 Aug 2009 21:48:33 GMT 2009-08-05T21:48:33Z Joining 2 resident tables https://community.qlik.com/t5/QlikView/Joining-2-resident-tables/m-p/151123#M29037 <HTML><HEAD></HEAD><BODY><P style="margin: 0cm 0cm 0pt;">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 style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">First table<BR />%ITM ,<BR />TTYPE,<BR />TQTY</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">Second table</P><P style="margin: 0cm 0cm 0pt;">DOCO,<BR />%ITM,<BR />QTY</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">I want to multiply QTY with TQTY and store this in a third table</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">table 3</P><P style="margin: 0cm 0cm 0pt;">DOCO,<BR />SERVICE,<BR />SCOST</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">Second.DOCO = DOCO<BR />first.TTYPE = SERVICE<BR />TQTY.QTY = SCOST</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">I dont know how to load info from 2 resident tables.</P><P style="margin: 0cm 0cm 0pt;">Who can help me</P><P style="margin: 0cm 0cm 0pt;"><BR /></P></BODY></HTML> Wed, 05 Aug 2009 20:59:07 GMT https://community.qlik.com/t5/QlikView/Joining-2-resident-tables/m-p/151123#M29037 2009-08-05T20:59:07Z Joining 2 resident tables https://community.qlik.com/t5/QlikView/Joining-2-resident-tables/m-p/151124#M29038 <HTML><HEAD></HEAD><BODY><P>close</P></BODY></HTML> Wed, 05 Aug 2009 21:48:33 GMT https://community.qlik.com/t5/QlikView/Joining-2-resident-tables/m-p/151124#M29038 2009-08-05T21:48:33Z