topic Re: How to get total field with auto increment in QlikView https://community.qlik.com/t5/QlikView/How-to-get-total-field-with-auto-increment/m-p/38648#M783767 <HTML><HEAD></HEAD><BODY><P>see also:</P><P><A href="https://community.qlik.com/thread/294971">how to add values to total</A></P></BODY></HTML> Fri, 16 Mar 2018 21:52:24 GMT MarcoWedel 2018-03-16T21:52:24Z How to get total field with auto increment https://community.qlik.com/t5/QlikView/How-to-get-total-field-with-auto-increment/m-p/38645#M783764 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>I have a source </P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 140px; height: 78px;"><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>Price</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">250</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">150</TD></TR></TBODY></TABLE><P></P><P></P><P>But i want to display with extra column like this </P><P></P><TABLE border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 184px; height: 83px;"><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>Price</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;">150</TD><TD style="padding: 2px;">500</TD></TR></TBODY></TABLE><P></P><P></P><P>How can I get total field by auto increment.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-total-field-with-auto-increment/m-p/38645#M783764 Anonymous 2020-11-25T16:16:04Z Re: How to get total field with auto increment https://community.qlik.com/t5/QlikView/How-to-get-total-field-with-auto-increment/m-p/38646#M783765 <HTML><HEAD></HEAD><BODY><P>Hey Amar</P><P></P><P>Use this</P><P>aggr( rangesum(above( sum(Price), 0, rowno() )), Price)&nbsp; </P></BODY></HTML> Fri, 16 Mar 2018 18:26:23 GMT https://community.qlik.com/t5/QlikView/How-to-get-total-field-with-auto-increment/m-p/38646#M783765 ychaitanya 2018-03-16T18:26:23Z Re: How to get total field with auto increment https://community.qlik.com/t5/QlikView/How-to-get-total-field-with-auto-increment/m-p/38647#M783766 <HTML><HEAD></HEAD><BODY><P>Looks like duplicate thread!!</P></BODY></HTML> Fri, 16 Mar 2018 19:18:34 GMT https://community.qlik.com/t5/QlikView/How-to-get-total-field-with-auto-increment/m-p/38647#M783766 Digvijay_Singh 2018-03-16T19:18:34Z Re: How to get total field with auto increment https://community.qlik.com/t5/QlikView/How-to-get-total-field-with-auto-increment/m-p/38648#M783767 <HTML><HEAD></HEAD><BODY><P>see also:</P><P><A href="https://community.qlik.com/thread/294971">how to add values to total</A></P></BODY></HTML> Fri, 16 Mar 2018 21:52:24 GMT https://community.qlik.com/t5/QlikView/How-to-get-total-field-with-auto-increment/m-p/38648#M783767 MarcoWedel 2018-03-16T21:52:24Z Re: How to get total field with auto increment https://community.qlik.com/t5/QlikView/How-to-get-total-field-with-auto-increment/m-p/38649#M783768 <HTML><HEAD></HEAD><BODY><P>Check this out.<IMG alt="1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196609_1.PNG" style="height: auto;" /></P></BODY></HTML> Sat, 17 Mar 2018 01:58:11 GMT https://community.qlik.com/t5/QlikView/How-to-get-total-field-with-auto-increment/m-p/38649#M783768 Qrishna 2018-03-17T01:58:11Z Re: How to get total field with auto increment https://community.qlik.com/t5/QlikView/How-to-get-total-field-with-auto-increment/m-p/38650#M783769 <HTML><HEAD></HEAD><BODY><P>Use this as expression</P><P></P><P>RangeSum(above(sum(Price),0,RowNo()))</P></BODY></HTML> Sat, 17 Mar 2018 02:47:12 GMT https://community.qlik.com/t5/QlikView/How-to-get-total-field-with-auto-increment/m-p/38650#M783769 shiveshsingh 2018-03-17T02:47:12Z