topic how can make two fields sum in QlikView https://community.qlik.com/t5/QlikView/how-can-make-two-fields-sum/m-p/192771#M54313 <HTML><HEAD></HEAD><BODY><P>go to properties menu check the check box in partial sum</P></BODY></HTML> Sat, 29 Jan 2011 11:34:29 GMT 2011-01-29T11:34:29Z how can make two fields sum https://community.qlik.com/t5/QlikView/how-can-make-two-fields-sum/m-p/192769#M54311 <HTML><HEAD></HEAD><BODY><P></P><P>Hi all,</P><P>I am beginer in QlikView, have one excel file with two fields. current inventory and unit cost. load file in QlikView. how can make sum on these fields?</P><P><IMG border="0" height="439" src="http://www.chichebiev.com/temp/inv.png" style="max-width: 550px; border: 0;" width="191" /></P><P>= (current inventory * unit cost)</P><P></P><P>Thank you</P><P></P></BODY></HTML> Sat, 29 Jan 2011 11:08:55 GMT https://community.qlik.com/t5/QlikView/how-can-make-two-fields-sum/m-p/192769#M54311 2011-01-29T11:08:55Z how can make two fields sum https://community.qlik.com/t5/QlikView/how-can-make-two-fields-sum/m-p/192770#M54312 <HTML><HEAD></HEAD><BODY><P>Load CurrentInventory, UnitCost, CurrentInventory * UnitCost as NewField</P><P>From ....;</P><P>If you want to use Sum() function then that too can be implemented easily using "Group By".</P><P>If you still have any issue, you can upload your sample application .</P><P>Regards, tresesco</P></BODY></HTML> Sat, 29 Jan 2011 11:32:00 GMT https://community.qlik.com/t5/QlikView/how-can-make-two-fields-sum/m-p/192770#M54312 tresB 2011-01-29T11:32:00Z how can make two fields sum https://community.qlik.com/t5/QlikView/how-can-make-two-fields-sum/m-p/192771#M54313 <HTML><HEAD></HEAD><BODY><P>go to properties menu check the check box in partial sum</P></BODY></HTML> Sat, 29 Jan 2011 11:34:29 GMT https://community.qlik.com/t5/QlikView/how-can-make-two-fields-sum/m-p/192771#M54313 2011-01-29T11:34:29Z how can make two fields sum https://community.qlik.com/t5/QlikView/how-can-make-two-fields-sum/m-p/192772#M54314 <HTML><HEAD></HEAD><BODY><P>I can not do this ! I Work with QlikView from two days, now learn :)bIf give me video tutorial, will help me too.</P><P>When select vendor number, sum all articles and show total sum =(unitCost*CurrentInventiry), for a vendor. I will be happy if someone help me.</P><P>Link for files <A href="http://chichebiev.com/temp/">http://chichebiev.com/temp/</A></P><P></P><P></P></BODY></HTML> Sat, 29 Jan 2011 13:37:53 GMT https://community.qlik.com/t5/QlikView/how-can-make-two-fields-sum/m-p/192772#M54314 2011-01-29T13:37:53Z how can make two fields sum https://community.qlik.com/t5/QlikView/how-can-make-two-fields-sum/m-p/192773#M54315 <HTML><HEAD></HEAD><BODY><P>I did it ! Thanks</P></BODY></HTML> Sat, 29 Jan 2011 14:34:37 GMT https://community.qlik.com/t5/QlikView/how-can-make-two-fields-sum/m-p/192773#M54315 2011-01-29T14:34:37Z