topic How to get the correct sum in QlikView https://community.qlik.com/t5/QlikView/How-to-get-the-correct-sum/m-p/301876#M111725 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use this:</P><P></P><P>Sum(TOTAL&lt;Month&gt; ValueField)</P><P></P><P></P><P>Regards,</P><P></P><P></P><P>Stephen</P></BODY></HTML> Tue, 24 Jan 2012 12:48:25 GMT stephencredmond 2012-01-24T12:48:25Z How to get the correct sum https://community.qlik.com/t5/QlikView/How-to-get-the-correct-sum/m-p/301875#M111724 <HTML><HEAD></HEAD><BODY><DIV>Hello all.</DIV><DIV> </DIV><DIV>I need to get a table of values with each row containing a column with the sum for the family in the respective month and another column with the sum for all families within the month.</DIV><DIV>Example:</DIV><DIV><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 256px; border-collapse: collapse;"><TBODY><TR style="height: 12.75pt;"><TD class="xl65" height="17" style="border: 0px windowtext; width: 48pt; height: 12.75pt; background-color: transparent;" width="64"><STRONG>Month</STRONG></TD><TD class="xl65" style="border: 0px windowtext; width: 48pt; background-color: transparent;" width="64"><STRONG style="color: #000000;">Family</STRONG></TD><TD class="xl65" style="border: 0px windowtext; width: 48pt; background-color: transparent;" width="64"><STRONG style="color: #000000;">Sum</STRONG></TD><TD class="xl65" style="border: 0px windowtext; width: 48pt; background-color: transparent;" width="64"><STRONG style="color: #000000;">Sum(2)</STRONG></TD></TR><TR style="height: 12.75pt;"><TD class="xl65" height="17" style="border: 0px windowtext; height: 12.75pt; background-color: transparent;"><STRONG>Jan</STRONG></TD><TD class="xl66" style="border: 0px windowtext; background-color: transparent;"><EM style="color: #000000;">Meat</EM></TD><TD align="right" style="border: 0px windowtext; background-color: transparent;"><SPAN style="color: #000000;">10</SPAN></TD><TD align="right" style="border: 0px windowtext; background-color: transparent;"><SPAN style="color: #000000;">25</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl65" height="17" style="border: 0px windowtext; height: 12.75pt; background-color: transparent;"><STRONG>Jan</STRONG></TD><TD class="xl66" style="border: 0px windowtext; background-color: transparent;"><EM style="color: #000000;">Fish</EM></TD><TD align="right" style="border: 0px windowtext; background-color: transparent;"><SPAN style="color: #000000;">5</SPAN></TD><TD align="right" style="border: 0px windowtext; background-color: transparent;"><SPAN style="color: #000000;">25</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl65" height="17" style="border: 0px windowtext; height: 12.75pt; background-color: transparent;"><STRONG>Jan</STRONG></TD><TD class="xl66" style="border: 0px windowtext; background-color: transparent;"><EM style="color: #000000;">Vegetables</EM></TD><TD align="right" style="border: 0px windowtext; background-color: transparent;"><SPAN style="color: #000000;">10</SPAN></TD><TD align="right" style="border: 0px windowtext; background-color: transparent;"><SPAN style="color: #000000;">25</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl65" height="17" style="border: 0px windowtext; height: 12.75pt; background-color: transparent;"><STRONG>Feb</STRONG></TD><TD class="xl66" style="border: 0px windowtext; background-color: transparent;"><EM style="color: #000000;">Meat</EM></TD><TD align="right" style="border: 0px windowtext; background-color: transparent;"><SPAN style="color: #000000;">15</SPAN></TD><TD align="right" style="border: 0px windowtext; background-color: transparent;"><SPAN style="color: #000000;">32</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl65" height="17" style="border: 0px windowtext; height: 12.75pt; background-color: transparent;"><STRONG>Feb</STRONG></TD><TD class="xl66" style="border: 0px windowtext; background-color: transparent;"><EM style="color: #000000;">Fish</EM></TD><TD align="right" style="border: 0px windowtext; background-color: transparent;"><SPAN style="color: #000000;">7</SPAN></TD><TD align="right" style="border: 0px windowtext; background-color: transparent;"><SPAN style="color: #000000;">32</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl65" height="17" style="border: 0px windowtext; height: 12.75pt; background-color: transparent;"><STRONG>Feb</STRONG></TD><TD class="xl66" style="border: 0px windowtext; background-color: transparent;"><EM style="color: #000000;">Vegetables</EM></TD><TD align="right" style="border: 0px windowtext; background-color: transparent;"><SPAN style="color: #000000;">10</SPAN></TD><TD align="right" style="border: 0px windowtext; background-color: transparent;"><SPAN style="color: #000000;">32</SPAN></TD></TR></TBODY></TABLE></DIV><P>I can get the values for "Sum", but i don't know how to do it for "Sum(2)".</P><P>Can anyone help?</P><P>Thank you.</P><P>Joaquim</P></BODY></HTML> Tue, 24 Jan 2012 12:42:15 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-correct-sum/m-p/301875#M111724 2012-01-24T12:42:15Z How to get the correct sum https://community.qlik.com/t5/QlikView/How-to-get-the-correct-sum/m-p/301876#M111725 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use this:</P><P></P><P>Sum(TOTAL&lt;Month&gt; ValueField)</P><P></P><P></P><P>Regards,</P><P></P><P></P><P>Stephen</P></BODY></HTML> Tue, 24 Jan 2012 12:48:25 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-correct-sum/m-p/301876#M111725 stephencredmond 2012-01-24T12:48:25Z Re: How to get the correct sum https://community.qlik.com/t5/QlikView/How-to-get-the-correct-sum/m-p/301877#M111726 <HTML><HEAD></HEAD><BODY><P> Thank you Stephen.</P><P>It was simple as that.</P><P>Joaquim</P></BODY></HTML> Tue, 24 Jan 2012 14:39:46 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-correct-sum/m-p/301877#M111726 2012-01-24T14:39:46Z