topic Re: add two fields from different tables in QlikView https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722762#M1058834 <HTML><HEAD></HEAD><BODY><P>May be it will help if you elaborate little more to the community. </P></BODY></HTML> Tue, 30 Sep 2014 06:36:24 GMT phaneendra_kunc 2014-09-30T06:36:24Z add two fields from different tables https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722761#M1058833 <HTML><HEAD></HEAD><BODY><P>hi</P><P>i need to add two fields from different tables. and check with condition like values &gt; 0&nbsp; and display it in chart for current month</P><P></P><P>any suggestions ?</P></BODY></HTML> Tue, 30 Sep 2014 06:34:12 GMT https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722761#M1058833 arulsettu 2014-09-30T06:34:12Z Re: add two fields from different tables https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722762#M1058834 <HTML><HEAD></HEAD><BODY><P>May be it will help if you elaborate little more to the community. </P></BODY></HTML> Tue, 30 Sep 2014 06:36:24 GMT https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722762#M1058834 phaneendra_kunc 2014-09-30T06:36:24Z Re: add two fields from different tables https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722763#M1058835 <HTML><HEAD></HEAD><BODY><P>hi</P><P>for example field1 from table1</P><P>and field two from table2</P><P>i need to add these two fields and check these fields value &gt; 0 </P></BODY></HTML> Tue, 30 Sep 2014 06:39:11 GMT https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722763#M1058835 arulsettu 2014-09-30T06:39:11Z Re: add two fields from different tables https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722764#M1058836 <HTML><HEAD></HEAD><BODY><P>so some thing like below ?</P><P>=if(Sum(Field1)+sum(Field2) &gt; 0, 'TRUE','FALSE')</P></BODY></HTML> Tue, 30 Sep 2014 06:43:47 GMT https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722764#M1058836 phaneendra_kunc 2014-09-30T06:43:47Z Re: add two fields from different tables https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722765#M1058837 <HTML><HEAD></HEAD><BODY><P>any help?</P></BODY></HTML> Tue, 30 Sep 2014 06:44:10 GMT https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722765#M1058837 arulsettu 2014-09-30T06:44:10Z Re: add two fields from different tables https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722766#M1058838 <HTML><HEAD></HEAD><BODY><P>What is the join key? </P></BODY></HTML> Tue, 30 Sep 2014 06:45:17 GMT https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722766#M1058838 anbu1984 2014-09-30T06:45:17Z Re: add two fields from different tables https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722767#M1058839 <HTML><HEAD></HEAD><BODY><P>condition like</P><P>orderquantity - shipped quantity </P><P>so it will check the values &gt; 0</P></BODY></HTML> Tue, 30 Sep 2014 06:48:05 GMT https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722767#M1058839 arulsettu 2014-09-30T06:48:05Z Re: add two fields from different tables https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722768#M1058840 <HTML><HEAD></HEAD><BODY><P>item number is join key</P></BODY></HTML> Tue, 30 Sep 2014 06:56:36 GMT https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722768#M1058840 arulsettu 2014-09-30T06:56:36Z Re: add two fields from different tables https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722769#M1058841 <HTML><HEAD></HEAD><BODY><P>mapping load with apply map would be helpful for this scenario? </P></BODY></HTML> Tue, 30 Sep 2014 07:03:17 GMT https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722769#M1058841 arulsettu 2014-09-30T07:03:17Z Re: add two fields from different tables https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722770#M1058842 <HTML><HEAD></HEAD><BODY><P>can you suggest any idea?</P></BODY></HTML> Tue, 30 Sep 2014 07:11:13 GMT https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722770#M1058842 arulsettu 2014-09-30T07:11:13Z Re: add two fields from different tables https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722771#M1058843 <HTML><HEAD></HEAD><BODY><P>Are your tables joined in script? <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">What do you want to do if diff is greater than 0?<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Can you post your sample qvw<BR /></SPAN></P></BODY></HTML> Tue, 30 Sep 2014 08:02:20 GMT https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722771#M1058843 anbu1984 2014-09-30T08:02:20Z Re: add two fields from different tables https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722772#M1058844 <HTML><HEAD></HEAD><BODY><P>can i send to your mail id?</P></BODY></HTML> Tue, 30 Sep 2014 08:07:02 GMT https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722772#M1058844 arulsettu 2014-09-30T08:07:02Z Re: add two fields from different tables https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722773#M1058845 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>can you upload the project?</P></BODY></HTML> Tue, 30 Sep 2014 08:19:54 GMT https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722773#M1058845 sorrakis01 2014-09-30T08:19:54Z Re: Re: add two fields from different tables https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722774#M1058846 <HTML><HEAD></HEAD><BODY><P>here it is</P><P></P><P>InvoiceQty from invoice table</P><P></P><P>QtyOrdered from orders table </P><P></P><P>add this two fields and check with condition <SPAN style="color: #1f497d; font-family: Calibri, sans-serif; font-size: 15px;"> <SPAN style="color: #000000;">(qtyordered – qtyshipped)&nbsp; (check if result is &gt; zero)</SPAN></SPAN></P><P></P><P>thanks</P></BODY></HTML> Tue, 30 Sep 2014 08:44:49 GMT https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722774#M1058846 arulsettu 2014-09-30T08:44:49Z Re: Re: add two fields from different tables https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722775#M1058847 <HTML><HEAD></HEAD><BODY><P>any help</P></BODY></HTML> Tue, 30 Sep 2014 09:30:41 GMT https://community.qlik.com/t5/QlikView/add-two-fields-from-different-tables/m-p/722775#M1058847 arulsettu 2014-09-30T09:30:41Z