topic Re: TOTAL ROWNO() in QlikView https://community.qlik.com/t5/QlikView/TOTAL-ROWNO/m-p/376158#M491867 <HTML><HEAD></HEAD><BODY><P>The correct rowno is 15?</P><P></P><P>Not sure why you want this, are you looking for the sum of rowno?</P><P></P><P><EM>=if(dimensionality(),rowno(TOTAL),sum(aggr(rowno(),DATA)))</EM></P><P></P><P>or may total rowno = 5:</P><P></P><P><EM>=if(dimensionality(),rowno(TOTAL),count(distinct DATA))</EM></P></BODY></HTML> Wed, 08 Aug 2012 13:24:13 GMT swuehl 2012-08-08T13:24:13Z TOTAL ROWNO() https://community.qlik.com/t5/QlikView/TOTAL-ROWNO/m-p/376157#M491866 <HTML><HEAD></HEAD><BODY><P>How to bring the rowno&nbsp; function&nbsp; total&nbsp; ()?</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="265"><TBODY><TR><TD class="xl67" height="17" width="68">DATA</TD><TD class="xl68" style="border-left: medium none;" width="98">RowNo</TD><TD class="xl69" style="border-left: medium none;" width="99">RowNo - Correct</TD></TR><TR><TD class="xl70" height="17" style="border-top: medium none;"> </TD><TD align="right" class="xl65" style="border-top: medium none;">0</TD><TD align="right" class="xl71" style="border-left: medium none; border-top: medium none;">15</TD></TR><TR><TD class="xl72" height="17" style="border-top: medium none;">31/12/2012</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">1</TD><TD align="right" class="xl73" style="border-left: medium none; border-top: medium none;">1</TD></TR><TR><TD class="xl72" height="17" style="border-top: medium none;">30/12/2012</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">2</TD><TD align="right" class="xl73" style="border-left: medium none; border-top: medium none;">2</TD></TR><TR><TD class="xl72" height="17" style="border-top: medium none;">23/01/2012</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">3</TD><TD align="right" class="xl73" style="border-left: medium none; border-top: medium none;">3</TD></TR><TR><TD class="xl72" height="17" style="border-top: medium none;">22/01/2012</TD><TD align="right" class="xl66" style="border-left: medium none; border-top: medium none;">4</TD><TD align="right" class="xl73" style="border-left: medium none; border-top: medium none;">4</TD></TR><TR><TD class="xl74" height="18" style="border-top: medium none;">21/01/2012</TD><TD align="right" class="xl75" style="border-left: medium none; border-top: medium none;">5</TD><TD align="right" class="xl76" style="border-left: medium none; border-top: medium none;">5</TD></TR></TBODY></TABLE><P></P><P>The total should be done within the expression.</P></BODY></HTML> Wed, 08 Aug 2012 13:18:41 GMT https://community.qlik.com/t5/QlikView/TOTAL-ROWNO/m-p/376157#M491866 Anonymous 2012-08-08T13:18:41Z Re: TOTAL ROWNO() https://community.qlik.com/t5/QlikView/TOTAL-ROWNO/m-p/376158#M491867 <HTML><HEAD></HEAD><BODY><P>The correct rowno is 15?</P><P></P><P>Not sure why you want this, are you looking for the sum of rowno?</P><P></P><P><EM>=if(dimensionality(),rowno(TOTAL),sum(aggr(rowno(),DATA)))</EM></P><P></P><P>or may total rowno = 5:</P><P></P><P><EM>=if(dimensionality(),rowno(TOTAL),count(distinct DATA))</EM></P></BODY></HTML> Wed, 08 Aug 2012 13:24:13 GMT https://community.qlik.com/t5/QlikView/TOTAL-ROWNO/m-p/376158#M491867 swuehl 2012-08-08T13:24:13Z Re: TOTAL ROWNO() https://community.qlik.com/t5/QlikView/TOTAL-ROWNO/m-p/376159#M491868 <HTML><HEAD></HEAD><BODY><P>Hi Alex,</P><P></P><P>i have attached application please chech out..This one slove your problems.</P></BODY></HTML> Wed, 08 Aug 2012 13:27:13 GMT https://community.qlik.com/t5/QlikView/TOTAL-ROWNO/m-p/376159#M491868 perumal_41 2012-08-08T13:27:13Z Re: TOTAL ROWNO() https://community.qlik.com/t5/QlikView/TOTAL-ROWNO/m-p/376160#M491869 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">When adding</SPAN> <SPAN class="hps">the function</SPAN> <SPAN class="hps">IF</SPAN> <SPAN class="hps">it</SPAN> <SPAN class="hps">does not total</SPAN> <SPAN class="hps">more.</SPAN></SPAN></P></BODY></HTML> Wed, 08 Aug 2012 14:14:46 GMT https://community.qlik.com/t5/QlikView/TOTAL-ROWNO/m-p/376160#M491869 Anonymous 2012-08-08T14:14:46Z