topic Re: Finding &quot;Total&quot; rows without using inter chart function in QlikView https://community.qlik.com/t5/QlikView/Finding-quot-Total-quot-rows-without-using-inter-chart-function/m-p/612726#M226114 <HTML><HEAD></HEAD><BODY><P><STRONG>=count(TOTAL FieldName)</STRONG></P></BODY></HTML> Tue, 08 Apr 2014 05:54:23 GMT sujeetsingh 2014-04-08T05:54:23Z Finding "Total" rows without using inter chart function https://community.qlik.com/t5/QlikView/Finding-quot-Total-quot-rows-without-using-inter-chart-function/m-p/612725#M226113 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I am using this expression to avoid "Total rows" from rendering any Date.</P><P>If(RowNo() &lt;&gt;0&nbsp; and not IsNull(RowNow())), TxnDate)..</P><P>I want to know if there is any way to find total rows without using RowNo() or dimensionality() in a pivot and straight chart.</P><P>-Saurabh </P></BODY></HTML> Tue, 08 Apr 2014 05:35:12 GMT https://community.qlik.com/t5/QlikView/Finding-quot-Total-quot-rows-without-using-inter-chart-function/m-p/612725#M226113 2014-04-08T05:35:12Z Re: Finding "Total" rows without using inter chart function https://community.qlik.com/t5/QlikView/Finding-quot-Total-quot-rows-without-using-inter-chart-function/m-p/612726#M226114 <HTML><HEAD></HEAD><BODY><P><STRONG>=count(TOTAL FieldName)</STRONG></P></BODY></HTML> Tue, 08 Apr 2014 05:54:23 GMT https://community.qlik.com/t5/QlikView/Finding-quot-Total-quot-rows-without-using-inter-chart-function/m-p/612726#M226114 sujeetsingh 2014-04-08T05:54:23Z Re: Finding "Total" rows without using inter chart function https://community.qlik.com/t5/QlikView/Finding-quot-Total-quot-rows-without-using-inter-chart-function/m-p/612727#M226115 <HTML><HEAD></HEAD><BODY><P>should i use</P><P>= count(TOTAL TxnDate)</P><P>and what is expected output of this function when it finds a TOTAL row...</P></BODY></HTML> Tue, 08 Apr 2014 06:28:37 GMT https://community.qlik.com/t5/QlikView/Finding-quot-Total-quot-rows-without-using-inter-chart-function/m-p/612727#M226115 2014-04-08T06:28:37Z