topic Re: how to add values to total in QlikView https://community.qlik.com/t5/QlikView/how-to-add-values-to-total/m-p/38589#M784926 <HTML><HEAD></HEAD><BODY><P>you can use like this :</P><P></P><P>above(sum(value),0,rowno()-1)</P><P></P><P>Thanks</P></BODY></HTML> Fri, 16 Mar 2018 18:10:51 GMT ychaitanya 2018-03-16T18:10:51Z how to add values to total https://community.qlik.com/t5/QlikView/how-to-add-values-to-total/m-p/38588#M784925 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need help,</P><P>How can I add values to the total field as shown below.</P><P></P><TABLE border="1" class="jiveBorder" height="174" style="border: 1px solid #000000; width: 138px; height: 173px;" width="136"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Value</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Total </STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">250</TD><TD style="padding: 2px;">350</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">400</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">450</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P>In my source I have only Product and value fields . How can I calculate Total Field.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-add-values-to-total/m-p/38588#M784925 Anonymous 2020-11-25T16:16:04Z Re: how to add values to total https://community.qlik.com/t5/QlikView/how-to-add-values-to-total/m-p/38589#M784926 <HTML><HEAD></HEAD><BODY><P>you can use like this :</P><P></P><P>above(sum(value),0,rowno()-1)</P><P></P><P>Thanks</P></BODY></HTML> Fri, 16 Mar 2018 18:10:51 GMT https://community.qlik.com/t5/QlikView/how-to-add-values-to-total/m-p/38589#M784926 ychaitanya 2018-03-16T18:10:51Z Re: how to add values to total https://community.qlik.com/t5/QlikView/how-to-add-values-to-total/m-p/38590#M784927 <HTML><HEAD></HEAD><BODY><P>Use this</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">aggr( rangesum(above( sum(Price), 0, rowno() )), Price) </P></BODY></HTML> Fri, 16 Mar 2018 18:32:06 GMT https://community.qlik.com/t5/QlikView/how-to-add-values-to-total/m-p/38590#M784927 ychaitanya 2018-03-16T18:32:06Z Re: how to add values to total https://community.qlik.com/t5/QlikView/how-to-add-values-to-total/m-p/38591#M784928 <HTML><HEAD></HEAD><BODY><P>May be this for Total measure - </P><P>Rangesum(Above(Sum(Value),0,Rowno()))</P></BODY></HTML> Fri, 16 Mar 2018 19:17:28 GMT https://community.qlik.com/t5/QlikView/how-to-add-values-to-total/m-p/38591#M784928 Digvijay_Singh 2018-03-16T19:17:28Z Re: how to add values to total https://community.qlik.com/t5/QlikView/how-to-add-values-to-total/m-p/38592#M784929 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>maybe helpful:</P><P><A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Straight_Table.htm#kanchor511" title="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Straight_Table.htm#kanchor511">https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Straight_Table.htm#kanchor511</A></P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Fri, 16 Mar 2018 21:50:56 GMT https://community.qlik.com/t5/QlikView/how-to-add-values-to-total/m-p/38592#M784929 MarcoWedel 2018-03-16T21:50:56Z Re: how to add values to total https://community.qlik.com/t5/QlikView/how-to-add-values-to-total/m-p/38593#M784930 <HTML><HEAD></HEAD><BODY><P>like this</P><P></P><P>RangeSum(above(sum(Price),0,RowNo()))</P></BODY></HTML> Sat, 17 Mar 2018 02:48:27 GMT https://community.qlik.com/t5/QlikView/how-to-add-values-to-total/m-p/38593#M784930 shiveshsingh 2018-03-17T02:48:27Z