topic Calculating data from different fields in QlikView https://community.qlik.com/t5/QlikView/Calculating-data-from-different-fields/m-p/865923#M302946 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a data set where I have three tables one is current sales table secound is budgeted sales and third is recent update sales tables.</P><P>All these tables contains same coloumn names. I dont know how to do calculation between these three tables. I used qualify statement to make these tables different but when I put product_class in dimension and in expression I calculate the sum of current sales and budgetd sales it doesnt give me exact numbers.&nbsp; </P><P></P><P>I am new to qlikview please help me to connect in between these tables and do the calculations.</P></BODY></HTML> Thu, 28 May 2015 05:47:39 GMT 2015-05-28T05:47:39Z Calculating data from different fields https://community.qlik.com/t5/QlikView/Calculating-data-from-different-fields/m-p/865923#M302946 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a data set where I have three tables one is current sales table secound is budgeted sales and third is recent update sales tables.</P><P>All these tables contains same coloumn names. I dont know how to do calculation between these three tables. I used qualify statement to make these tables different but when I put product_class in dimension and in expression I calculate the sum of current sales and budgetd sales it doesnt give me exact numbers.&nbsp; </P><P></P><P>I am new to qlikview please help me to connect in between these tables and do the calculations.</P></BODY></HTML> Thu, 28 May 2015 05:47:39 GMT https://community.qlik.com/t5/QlikView/Calculating-data-from-different-fields/m-p/865923#M302946 2015-05-28T05:47:39Z