topic Re: Calculated Field using 2 Tables in QlikView https://community.qlik.com/t5/QlikView/Calculated-Field-using-2-Tables/m-p/354683#M1176813 <HTML><HEAD></HEAD><BODY><P>I don't know if this will help you but here's a simple example:</P><P></P><P>test:</P><P>LOAD * INLINE [</P><P>ARTNBR, NUMBER1</P><P>3154, 1000</P><P>3154, 857</P><P>3169, 455</P><P>3169, 3542</P><P>]</P><P>;</P><P></P><P>inner join</P><P></P><P>LOAD * INLINE [</P><P>ARTNBR, NUMBER2</P><P>3154, 50</P><P>3169, 222</P><P>];</P><P></P><P></P><P>test2:</P><P>LOAD *,</P><P>NUMBER1 - NUMBER2 as NUMBER_DIFFERENCE</P><P>Resident test;</P><P></P><P>drop table test;</P><P></P><P>NUMBER_DIFFERENCE is a calculated field using 2 fields in 2 different tables.&nbsp; I also attached a qvw for additional help if you need it.</P><P></P><P>Hope this helps!</P></BODY></HTML> Thu, 15 Mar 2012 16:57:46 GMT 2012-03-15T16:57:46Z Calculated Field using 2 Tables https://community.qlik.com/t5/QlikView/Calculated-Field-using-2-Tables/m-p/354682#M1176812 <HTML><HEAD></HEAD><BODY><P>Hello All, </P><P></P><P>I am trying to create a calculated field in my script using 2 fields in 2 different tables. I know it's something simple but I would appreciate some help. </P></BODY></HTML> Thu, 15 Mar 2012 15:27:00 GMT https://community.qlik.com/t5/QlikView/Calculated-Field-using-2-Tables/m-p/354682#M1176812 2012-03-15T15:27:00Z Re: Calculated Field using 2 Tables https://community.qlik.com/t5/QlikView/Calculated-Field-using-2-Tables/m-p/354683#M1176813 <HTML><HEAD></HEAD><BODY><P>I don't know if this will help you but here's a simple example:</P><P></P><P>test:</P><P>LOAD * INLINE [</P><P>ARTNBR, NUMBER1</P><P>3154, 1000</P><P>3154, 857</P><P>3169, 455</P><P>3169, 3542</P><P>]</P><P>;</P><P></P><P>inner join</P><P></P><P>LOAD * INLINE [</P><P>ARTNBR, NUMBER2</P><P>3154, 50</P><P>3169, 222</P><P>];</P><P></P><P></P><P>test2:</P><P>LOAD *,</P><P>NUMBER1 - NUMBER2 as NUMBER_DIFFERENCE</P><P>Resident test;</P><P></P><P>drop table test;</P><P></P><P>NUMBER_DIFFERENCE is a calculated field using 2 fields in 2 different tables.&nbsp; I also attached a qvw for additional help if you need it.</P><P></P><P>Hope this helps!</P></BODY></HTML> Thu, 15 Mar 2012 16:57:46 GMT https://community.qlik.com/t5/QlikView/Calculated-Field-using-2-Tables/m-p/354683#M1176813 2012-03-15T16:57:46Z