topic Count Rows in Ad Hoc Report in QlikView https://community.qlik.com/t5/QlikView/Count-Rows-in-Ad-Hoc-Report/m-p/956607#M526268 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">I have an Ad Hoc report that I need to state how many rows are included in the file so that the user knows if it will exceed the max rows that Excel can handle (something like 1.048 m I think).</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">I tried creating a variable called vGetFields =<SPAN style="color: #0000ff;">GetFieldSelections</SPAN>(<SPAN style="color: #800000;">_Dimension</SPAN>, ' &amp; ',100) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">and then a Text Box: ='Number of Lines ' &amp; <SPAN style="color: #0000ff;">Count</SPAN>(<SPAN style="color: #0000ff;">distinct</SPAN> <STRONG><EM style=": ; color: #808080;">$(vGetFields)</EM></STRONG>) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">but it is not working as I intended. For example, if the Dimensions I have selected result in one row of data, it should read 1.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Any ideas?</SPAN></P><P></P><P><SPAN><SPAN style="font-size: 10pt;">Thanks,</SPAN><BR /><BR /><SPAN style="font-size: 10pt;">Cassandra</SPAN></SPAN></P></BODY></HTML> Fri, 04 Dec 2015 17:30:37 GMT cbaqir 2015-12-04T17:30:37Z Count Rows in Ad Hoc Report https://community.qlik.com/t5/QlikView/Count-Rows-in-Ad-Hoc-Report/m-p/956607#M526268 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">I have an Ad Hoc report that I need to state how many rows are included in the file so that the user knows if it will exceed the max rows that Excel can handle (something like 1.048 m I think).</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">I tried creating a variable called vGetFields =<SPAN style="color: #0000ff;">GetFieldSelections</SPAN>(<SPAN style="color: #800000;">_Dimension</SPAN>, ' &amp; ',100) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">and then a Text Box: ='Number of Lines ' &amp; <SPAN style="color: #0000ff;">Count</SPAN>(<SPAN style="color: #0000ff;">distinct</SPAN> <STRONG><EM style=": ; color: #808080;">$(vGetFields)</EM></STRONG>) </SPAN></P><P></P><P><SPAN style="font-size: 10pt;">but it is not working as I intended. For example, if the Dimensions I have selected result in one row of data, it should read 1.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Any ideas?</SPAN></P><P></P><P><SPAN><SPAN style="font-size: 10pt;">Thanks,</SPAN><BR /><BR /><SPAN style="font-size: 10pt;">Cassandra</SPAN></SPAN></P></BODY></HTML> Fri, 04 Dec 2015 17:30:37 GMT https://community.qlik.com/t5/QlikView/Count-Rows-in-Ad-Hoc-Report/m-p/956607#M526268 cbaqir 2015-12-04T17:30:37Z Re: Count Rows in Ad Hoc Report https://community.qlik.com/t5/QlikView/Count-Rows-in-Ad-Hoc-Report/m-p/956608#M526269 <HTML><HEAD></HEAD><BODY><P>maybe Gysbert's answer can help you</P><P><A href="https://community.qlik.com/message/786004">How to count rows from conditional chart table fields in text object</A></P></BODY></HTML> Fri, 04 Dec 2015 17:32:57 GMT https://community.qlik.com/t5/QlikView/Count-Rows-in-Ad-Hoc-Report/m-p/956608#M526269 maxgro 2015-12-04T17:32:57Z