topic Re: Number of table rows in QlikView https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079528#M359898 <HTML><HEAD></HEAD><BODY><P>Thank you, but this construction is strictly predefined and I cannot select other fruit - for example, "peach" </P></BODY></HTML> Sun, 21 Feb 2016 16:31:47 GMT Anonymous 2016-02-21T16:31:47Z Number of table rows https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079524#M359894 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm trying to sort the table by sales column but it does not work. Do you have any ideas on that? Please see attached file for example.</P><P></P><P>Thank you for your ideas.</P></BODY></HTML> Sun, 21 Feb 2016 15:37:01 GMT https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079524#M359894 Anonymous 2016-02-21T15:37:01Z Re: Number of table rows https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079525#M359895 <HTML><HEAD></HEAD><BODY><P>May be sort by your dimension using an expression:</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/115357_Capture.PNG" style="height: 255px; width: 620px;" /></P></BODY></HTML> Sun, 21 Feb 2016 16:12:34 GMT https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079525#M359895 sunny_talwar 2016-02-21T16:12:34Z Re: Number of table rows https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079526#M359896 <HTML><HEAD></HEAD><BODY><P>Do you need the Rowno(TOTAL) expression? Without that you can sort as usual double clicking on the label</P></BODY></HTML> Sun, 21 Feb 2016 16:19:21 GMT https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079526#M359896 maxgro 2016-02-21T16:19:21Z Re: Number of table rows https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079527#M359897 <HTML><HEAD></HEAD><BODY><P>Yes. I need to show number of rows in the table. Maybe it's possible to use any other expression to show number of row? </P></BODY></HTML> Sun, 21 Feb 2016 16:27:01 GMT https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079527#M359897 Anonymous 2016-02-21T16:27:01Z Re: Number of table rows https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079528#M359898 <HTML><HEAD></HEAD><BODY><P>Thank you, but this construction is strictly predefined and I cannot select other fruit - for example, "peach" </P></BODY></HTML> Sun, 21 Feb 2016 16:31:47 GMT https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079528#M359898 Anonymous 2016-02-21T16:31:47Z Re: Number of table rows https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079529#M359899 <HTML><HEAD></HEAD><BODY><P>I don't understand? We are looking at just apple and the data is sorted in the descending order. Not sure what the issue is? Can you elaborate may be?</P></BODY></HTML> Sun, 21 Feb 2016 16:36:40 GMT https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079529#M359899 sunny_talwar 2016-02-21T16:36:40Z Re: Number of table rows https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079530#M359900 <HTML><HEAD></HEAD><BODY><P>Not sure what you are trying to achieve with the rownumber, but if you want to show a rank, try</P><P></P><P>=Rank(TOTAL "Sales",4)</P><P></P><P>instead.</P></BODY></HTML> Sun, 21 Feb 2016 16:58:22 GMT https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079530#M359900 swuehl 2016-02-21T16:58:22Z Re: Number of table rows https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079531#M359901 <HTML><HEAD></HEAD><BODY><P>Thank you - it's what I need and it works.</P></BODY></HTML> Mon, 22 Feb 2016 15:27:55 GMT https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079531#M359901 Anonymous 2016-02-22T15:27:55Z Re: Number of table rows https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079532#M359902 <HTML><HEAD></HEAD><BODY><P>Thank you, this question was solved.</P></BODY></HTML> Mon, 22 Feb 2016 15:28:44 GMT https://community.qlik.com/t5/QlikView/Number-of-table-rows/m-p/1079532#M359902 Anonymous 2016-02-22T15:28:44Z