topic Re: Calculated Field from 2 Tables in QlikView https://community.qlik.com/t5/QlikView/Calculated-Field-from-2-Tables/m-p/1099512#M634199 <HTML><HEAD></HEAD><BODY><P>How many mapping tables I can create ?</P></BODY></HTML> Tue, 31 May 2016 16:09:25 GMT 2016-05-31T16:09:25Z Calculated Field from 2 Tables https://community.qlik.com/t5/QlikView/Calculated-Field-from-2-Tables/m-p/1099510#M634197 <HTML><HEAD></HEAD><BODY><P>hi</P><P>I have 2 tables :</P><P>Tbl1:</P><P>productID</P><P>Price</P><P></P><P>tbl2:</P><P>QTY</P><P>ProductID</P><P></P><P>I need to make field as <SPAN style="text-decoration: underline;"><SPAN style="color: #575757; text-decoration: underline;">Price*QTY= TOTAL SALES</SPAN></SPAN></P><P><SPAN style="text-decoration: underline;"></SPAN></P><P><SPAN style="color: #575757;">i make other table as :</SPAN></P><P><SPAN style="color: #575757;">load price</SPAN></P><P><SPAN style="color: #575757;"> from Tbl1;</SPAN></P><P><SPAN style="color: #575757;">join</SPAN></P><P><SPAN style="color: #575757;">load&nbsp; QTY from Tbl2;</SPAN></P><P></P><P><SPAN style="color: #575757;">but is make many tables and cant make new field.......</SPAN></P><P></P><P><SPAN style="color: #575757;">how to join is ???</SPAN></P></BODY></HTML> Tue, 31 May 2016 15:09:09 GMT https://community.qlik.com/t5/QlikView/Calculated-Field-from-2-Tables/m-p/1099510#M634197 2016-05-31T15:09:09Z Re: Calculated Field from 2 Tables https://community.qlik.com/t5/QlikView/Calculated-Field-from-2-Tables/m-p/1099511#M634198 <HTML><HEAD></HEAD><BODY><P>May be try with the mapping load:</P><P></P><P><STRONG>MappingTable:</STRONG></P><P><STRONG>Mapping</STRONG></P><P><STRONG>LOAD ProductID,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; QTY</STRONG></P><P><STRONG>FROM...</STRONG></P><P></P><P><STRONG>Tbl1:</STRONG></P><P><STRONG>LOAD ProductID,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Price,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Price * ApplyMap('MappingTable', ProductID) as [Total Sales]</STRONG></P><P><STRONG>FROM ....</STRONG></P></BODY></HTML> Tue, 31 May 2016 15:57:05 GMT https://community.qlik.com/t5/QlikView/Calculated-Field-from-2-Tables/m-p/1099511#M634198 sunny_talwar 2016-05-31T15:57:05Z Re: Calculated Field from 2 Tables https://community.qlik.com/t5/QlikView/Calculated-Field-from-2-Tables/m-p/1099512#M634199 <HTML><HEAD></HEAD><BODY><P>How many mapping tables I can create ?</P></BODY></HTML> Tue, 31 May 2016 16:09:25 GMT https://community.qlik.com/t5/QlikView/Calculated-Field-from-2-Tables/m-p/1099512#M634199 2016-05-31T16:09:25Z Re: Calculated Field from 2 Tables https://community.qlik.com/t5/QlikView/Calculated-Field-from-2-Tables/m-p/1099513#M634200 <HTML><HEAD></HEAD><BODY><P>In theory unlimited.</P><P>So if you want to create 8000 mapping tables: Have fun.</P></BODY></HTML> Tue, 31 May 2016 16:14:43 GMT https://community.qlik.com/t5/QlikView/Calculated-Field-from-2-Tables/m-p/1099513#M634200 oknotsen 2016-05-31T16:14:43Z Re: Calculated Field from 2 Tables https://community.qlik.com/t5/QlikView/Calculated-Field-from-2-Tables/m-p/1099514#M634201 <HTML><HEAD></HEAD><BODY><P>But</P><P>mapping table include only 2 columns</P><P></P><P>if i work with 10 Tables.....for any new field i need made new mapping table............</P></BODY></HTML> Tue, 31 May 2016 16:36:37 GMT https://community.qlik.com/t5/QlikView/Calculated-Field-from-2-Tables/m-p/1099514#M634201 2016-05-31T16:36:37Z Re: Calculated Field from 2 Tables https://community.qlik.com/t5/QlikView/Calculated-Field-from-2-Tables/m-p/1099515#M634202 <HTML><HEAD></HEAD><BODY><P>You need all those fields in calculations?</P><P>If not, use JOIN the tables instead.</P></BODY></HTML> Tue, 31 May 2016 20:04:41 GMT https://community.qlik.com/t5/QlikView/Calculated-Field-from-2-Tables/m-p/1099515#M634202 oknotsen 2016-05-31T20:04:41Z