topic maya180504 in QlikView https://community.qlik.com/t5/QlikView/maya180504/m-p/180315#M46785 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>The result should look like the following</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">FieldToMultiplyMap:MAPPING LOAD ID, MULTIPLIERFROM Source; TableMultiplied:LOAD ID, CANTIDAD, APPLYMAP('FieldToMultiplyMap', ID, 1) AS CANTIDAD_MULTIPLICADARESIDENT Table;</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope this helps</P></BODY></HTML> Fri, 25 Mar 2011 09:06:20 GMT Miguel_Angel_Baeyens 2011-03-25T09:06:20Z maya180504 https://community.qlik.com/t5/QlikView/maya180504/m-p/180314#M46784 <HTML><HEAD></HEAD><BODY><P>Hello!. I have a doubt. I like to do a query on a table something like</P><P>TblTemp:</P><P>Load Cantidad,CCY</P><P>Resident SPSH_NORMAL</P><P></P><P>In this table multiply the result by another field in another table. The result of the operation is summary.</P><P></P><P>Please help me with this question. Thanks in advance<BR /></P></BODY></HTML> Fri, 25 Mar 2011 06:40:34 GMT https://community.qlik.com/t5/QlikView/maya180504/m-p/180314#M46784 2011-03-25T06:40:34Z maya180504 https://community.qlik.com/t5/QlikView/maya180504/m-p/180315#M46785 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>The result should look like the following</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">FieldToMultiplyMap:MAPPING LOAD ID, MULTIPLIERFROM Source; TableMultiplied:LOAD ID, CANTIDAD, APPLYMAP('FieldToMultiplyMap', ID, 1) AS CANTIDAD_MULTIPLICADARESIDENT Table;</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope this helps</P></BODY></HTML> Fri, 25 Mar 2011 09:06:20 GMT https://community.qlik.com/t5/QlikView/maya180504/m-p/180315#M46785 Miguel_Angel_Baeyens 2011-03-25T09:06:20Z