topic Partial Sum in QlikView https://community.qlik.com/t5/QlikView/Partial-Sum/m-p/276584#M496133 <HTML><HEAD></HEAD><BODY><P><EM>Hi,</EM></P><P></P><P><EM>Could please elaborate your question with expected answer?</EM></P><P></P><P><EM>Total Amount Could be also calculated using <STRONG>=sum(Cost*Qty)</STRONG> formulae.</EM></P><P></P><P><EM>Avg Unit Cost could be calculated using <STRONG>Avg(Cost)</STRONG>.</EM></P><P></P><P><EM>If this is not you are expecting then give us the some more information you question with expected answers.</EM></P><P></P><P><EM>-Sridhar</EM></P></BODY></HTML> Sat, 03 Dec 2011 03:57:35 GMT sridhar240784 2011-12-03T03:57:35Z Partial Sum https://community.qlik.com/t5/QlikView/Partial-Sum/m-p/276583#M496132 <HTML><HEAD></HEAD><BODY><P>Dear all</P><P></P><P>The Total in Unit Cost ($327) and Amounts columns ($20,928) are incorrect, need your help to advise how to compute the Average Unit Cost and Total Amount ?.</P><P></P><P>Thank you</P><P>Tracy.</P></BODY></HTML> Sat, 03 Dec 2011 01:46:59 GMT https://community.qlik.com/t5/QlikView/Partial-Sum/m-p/276583#M496132 tracycrown 2011-12-03T01:46:59Z Partial Sum https://community.qlik.com/t5/QlikView/Partial-Sum/m-p/276584#M496133 <HTML><HEAD></HEAD><BODY><P><EM>Hi,</EM></P><P></P><P><EM>Could please elaborate your question with expected answer?</EM></P><P></P><P><EM>Total Amount Could be also calculated using <STRONG>=sum(Cost*Qty)</STRONG> formulae.</EM></P><P></P><P><EM>Avg Unit Cost could be calculated using <STRONG>Avg(Cost)</STRONG>.</EM></P><P></P><P><EM>If this is not you are expecting then give us the some more information you question with expected answers.</EM></P><P></P><P><EM>-Sridhar</EM></P></BODY></HTML> Sat, 03 Dec 2011 03:57:35 GMT https://community.qlik.com/t5/QlikView/Partial-Sum/m-p/276584#M496133 sridhar240784 2011-12-03T03:57:35Z Re: Partial Sum https://community.qlik.com/t5/QlikView/Partial-Sum/m-p/276585#M496134 <HTML><HEAD></HEAD><BODY><P>Dear Sridhar</P><P> </P><P>The Total for Amount is correct now ($4339) but not the Total Unit Cost ($65.4), it should be Total Amount/Total Qty = ($4339/64=$67.8).</P><P> </P><P>Thank you</P><P>Tracy</P><P> </P><P></P><P></P><P></P><P>Date: Fri, 2 Dec 2011 22:57:54 -0500</P><P>From: qliktech@sgaur.hosted.jivesoftware.com</P><P>To: tracycrown@hotmail.com</P><P>Subject: <A href="Development (QlikView Desktop)"></A> - Re: Partial Sum</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P>QlikCommunity</P><P></P><P></P><P>Re: Partial Sum created by Sridhar Ethiraj in Development (QlikView Desktop) - View the full discussion </P><P></P><P></P><P></P><P>Hi,</P><P> </P><P>Could please elaborate your question with expected answer?</P><P> </P><P>Total Amount Could be also calculated using =sum(Cost*Qty) formulae.</P><P> </P><P>Avg Unit Cost could be calculated using Avg(Cost).</P><P> </P><P>If this is not you are expecting then give us the some more information you question with expected answers.</P><P> </P><P>-Sridhar</P><P></P><P>Reply to this message by replying to this email -or- go to the message on QlikCommunity</P><P>Start a new discussion in Development (QlikView Desktop) by email or at QlikCommunity</P><P>© 1993-2011 QlikTech International AB Copyright &amp; Trademarks | Privacy | Terms of Use | Software EULA</P></BODY></HTML> Sat, 03 Dec 2011 06:31:14 GMT https://community.qlik.com/t5/QlikView/Partial-Sum/m-p/276585#M496134 tracycrown 2011-12-03T06:31:14Z Re: Partial Sum https://community.qlik.com/t5/QlikView/Partial-Sum/m-p/276586#M496135 <HTML><HEAD></HEAD><BODY><P><EM>You can use this below formulae to calculate Total Unit Cost </EM></P><P></P><P><STRONG><EM>sum(Cost*Qty)/sum(Qty)</EM></STRONG></P><P></P><P><EM>-Sridhar</EM></P></BODY></HTML> Sat, 03 Dec 2011 10:18:03 GMT https://community.qlik.com/t5/QlikView/Partial-Sum/m-p/276586#M496135 sridhar240784 2011-12-03T10:18:03Z Re: Partial Sum https://community.qlik.com/t5/QlikView/Partial-Sum/m-p/276587#M496136 <HTML><HEAD></HEAD><BODY><P>Dear Sridhar</P><P> </P><P>Unit Cost and Qty are inputed by the user, please advise why should I create a formula to compute Unit Cost again ?.</P><P> </P><P>Thank you</P><P>Tracy</P><P></P><P> </P><P></P><P></P><P></P><P>Date: Sat, 3 Dec 2011 05:18:16 -0500</P><P>From: qliktech@sgaur.hosted.jivesoftware.com</P><P>To: tracycrown@hotmail.com</P><P>Subject: <A href="Development (QlikView Desktop)"></A> - Re: Partial Sum</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P>QlikCommunity</P><P></P><P></P><P>Re: Partial Sum created by Sridhar Ethiraj in Development (QlikView Desktop) - View the full discussion </P><P></P><P></P><P></P><P>You can use this below formulae to calculate Total Unit Cost </P><P> </P><P>sum((Cost*Qty))/sum(Qty)</P><P> </P><P>-Sridhar</P><P></P><P>Reply to this message by replying to this email -or- go to the message on QlikCommunity</P><P>Start a new discussion in Development (QlikView Desktop) by email or at QlikCommunity</P><P>© 1993-2011 QlikTech International AB Copyright &amp; Trademarks | Privacy | Terms of Use | Software EULA</P></BODY></HTML> Sat, 03 Dec 2011 15:52:25 GMT https://community.qlik.com/t5/QlikView/Partial-Sum/m-p/276587#M496136 tracycrown 2011-12-03T15:52:25Z