topic partial sum in QlikView https://community.qlik.com/t5/QlikView/partial-sum/m-p/917868#M318221 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a pivot table in my data table and output report is as follows</P><P></P><TABLE><TBODY><TR><TD>BRANCH</TD><TD>ITEM</TD><TD>SUM(QTY)</TD><TD>SUM(UNIT_PRICE)</TD><TD>(QTY)*(UNIT_PRICE)</TD></TR><TR><TD>ABC</TD><TD>Card Printers=165000</TD><TD>1</TD><TD>165,000</TD><TD>165,000</TD></TR><TR><TD>ABC</TD><TD>CPU=81000</TD><TD>1</TD><TD>90,000</TD><TD>90,000</TD></TR><TR><TD>ABC</TD><TD>Dot Matrix Printers=75000</TD><TD>0</TD><TD>75,000</TD><TD>0</TD></TR><TR><TD>ABC</TD><TD>High End Scan Kodak=128000</TD><TD>0</TD><TD>128,000</TD><TD>0</TD></TR><TR><TD>ABC</TD><TD>HP 401 Printers=45000</TD><TD>1</TD><TD>45,000</TD><TD>45,000</TD></TR><TR><TD>ABC</TD><TD>Scanners G3110=19000</TD><TD>1</TD><TD>19,000</TD><TD>19,000</TD></TR><TR><TD>ABC</TD><TD>TFT Panels=13000</TD><TD>1</TD><TD>13,000</TD><TD>13,000</TD></TR><TR><TD>ABC</TD><TD>UPS (3.0kva)=120000</TD><TD>0</TD><TD>120,000</TD><TD>0</TD></TR><TR><TD>ABC</TD><TD>UPS (650VA)=5000</TD><TD>1</TD><TD>5,000</TD><TD>5,000</TD></TR><TR><TD>ABC</TD><TD>Total</TD><TD>6</TD><TD>660,000</TD><TD>-</TD></TR></TBODY></TABLE><P></P><P>Here I do not get total in last column (qty)*unit_price) .Pls advise me where I have gone wrong</P></BODY></HTML> Tue, 28 Jul 2015 10:54:02 GMT upaliwije 2015-07-28T10:54:02Z partial sum https://community.qlik.com/t5/QlikView/partial-sum/m-p/917868#M318221 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a pivot table in my data table and output report is as follows</P><P></P><TABLE><TBODY><TR><TD>BRANCH</TD><TD>ITEM</TD><TD>SUM(QTY)</TD><TD>SUM(UNIT_PRICE)</TD><TD>(QTY)*(UNIT_PRICE)</TD></TR><TR><TD>ABC</TD><TD>Card Printers=165000</TD><TD>1</TD><TD>165,000</TD><TD>165,000</TD></TR><TR><TD>ABC</TD><TD>CPU=81000</TD><TD>1</TD><TD>90,000</TD><TD>90,000</TD></TR><TR><TD>ABC</TD><TD>Dot Matrix Printers=75000</TD><TD>0</TD><TD>75,000</TD><TD>0</TD></TR><TR><TD>ABC</TD><TD>High End Scan Kodak=128000</TD><TD>0</TD><TD>128,000</TD><TD>0</TD></TR><TR><TD>ABC</TD><TD>HP 401 Printers=45000</TD><TD>1</TD><TD>45,000</TD><TD>45,000</TD></TR><TR><TD>ABC</TD><TD>Scanners G3110=19000</TD><TD>1</TD><TD>19,000</TD><TD>19,000</TD></TR><TR><TD>ABC</TD><TD>TFT Panels=13000</TD><TD>1</TD><TD>13,000</TD><TD>13,000</TD></TR><TR><TD>ABC</TD><TD>UPS (3.0kva)=120000</TD><TD>0</TD><TD>120,000</TD><TD>0</TD></TR><TR><TD>ABC</TD><TD>UPS (650VA)=5000</TD><TD>1</TD><TD>5,000</TD><TD>5,000</TD></TR><TR><TD>ABC</TD><TD>Total</TD><TD>6</TD><TD>660,000</TD><TD>-</TD></TR></TBODY></TABLE><P></P><P>Here I do not get total in last column (qty)*unit_price) .Pls advise me where I have gone wrong</P></BODY></HTML> Tue, 28 Jul 2015 10:54:02 GMT https://community.qlik.com/t5/QlikView/partial-sum/m-p/917868#M318221 upaliwije 2015-07-28T10:54:02Z Re: partial sum https://community.qlik.com/t5/QlikView/partial-sum/m-p/917869#M318222 <HTML><HEAD></HEAD><BODY><P>You should not be using 'naked' fields* - for the last column you need:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sum(QTY * UNIT_PRICE)</P><P></P><P>* fields not wrapped by one or other aggregation function (like Sum(), Max(), Count()...)</P></BODY></HTML> Tue, 28 Jul 2015 10:57:26 GMT https://community.qlik.com/t5/QlikView/partial-sum/m-p/917869#M318222 jonathandienst 2015-07-28T10:57:26Z Re: partial sum https://community.qlik.com/t5/QlikView/partial-sum/m-p/917870#M318223 <HTML><HEAD></HEAD><BODY><P>Working sample from your data using the expression provided by <A _jive_internal="true" href="https://community.qlik.com/people/jontydkpi">jonathan</A></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/94251_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 28 Jul 2015 11:13:00 GMT https://community.qlik.com/t5/QlikView/partial-sum/m-p/917870#M318223 sunny_talwar 2015-07-28T11:13:00Z