topic Re: How to get First five rows in a straight table??? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-First-five-rows-in-a-straight-table/m-p/390809#M568418 <HTML><HEAD></HEAD><BODY><P>On the Presentation tab of the properties screen set Max Number (1-100) to 5. Then only 5 rows will be shown.</P></BODY></HTML> Thu, 01 Nov 2012 08:34:48 GMT Gysbert_Wassenaar 2012-11-01T08:34:48Z How to get First five rows in a straight table??? https://community.qlik.com/t5/QlikView/How-to-get-First-five-rows-in-a-straight-table/m-p/390808#M568417 <HTML><HEAD></HEAD><BODY><P>Hi Qlikies,</P><P></P><P>I am new to Qlikview.. My purpose here is to get top 5 rows in a straight table..</P><P>Actually if we do like this in edit script we'll get a new field right? </P><P></P><P>SELECT TOP 5 * FROM TABLENAME; </P><P></P><P>but thats not the thing I want.</P><P>For example the following is a straight table..</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="257" style="width: 500px; border: 1px solid rgb(0, 0, 0); height: 259px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 2</STRONG></SPAN></TH></TR><TR><TD>sai</TD><TD>5236</TD></TR><TR><TD>anu</TD><TD>7410</TD></TR><TR><TD>sbndjkh</TD><TD>5263</TD></TR><TR><TD>nkhk</TD><TD>8846</TD></TR><TR><TD>Harish</TD><TD>54645</TD></TR><TR><TD>jhbyjhg</TD><TD>548464</TD></TR><TR><TD>bhbvhbh</TD><TD>534564</TD></TR><TR><TD>mvbhjvghk</TD><TD>55343</TD></TR><TR><TD>bhbh</TD><TD>5354</TD></TR><TR><TD>nmbjbjk</TD><TD>53153</TD></TR></TBODY></TABLE><P></P><P></P><P>So here I want Details only upto Harish...for that what expression we have to use?? </P><P>Or what we have to do??</P><P></P><P>Thank you all...Please Help and do reply</P><P></P><P>Soon reply is appreciated.. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 01 Nov 2012 08:28:17 GMT https://community.qlik.com/t5/QlikView/How-to-get-First-five-rows-in-a-straight-table/m-p/390808#M568417 2012-11-01T08:28:17Z Re: How to get First five rows in a straight table??? https://community.qlik.com/t5/QlikView/How-to-get-First-five-rows-in-a-straight-table/m-p/390809#M568418 <HTML><HEAD></HEAD><BODY><P>On the Presentation tab of the properties screen set Max Number (1-100) to 5. Then only 5 rows will be shown.</P></BODY></HTML> Thu, 01 Nov 2012 08:34:48 GMT https://community.qlik.com/t5/QlikView/How-to-get-First-five-rows-in-a-straight-table/m-p/390809#M568418 Gysbert_Wassenaar 2012-11-01T08:34:48Z Re: How to get First five rows in a straight table??? https://community.qlik.com/t5/QlikView/How-to-get-First-five-rows-in-a-straight-table/m-p/390810#M568419 <HTML><HEAD></HEAD><BODY><P>Oh wow thank you so much Gysbert...!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 01 Nov 2012 09:27:27 GMT https://community.qlik.com/t5/QlikView/How-to-get-First-five-rows-in-a-straight-table/m-p/390810#M568419 2012-11-01T09:27:27Z Re: How to get First five rows in a straight table??? https://community.qlik.com/t5/QlikView/How-to-get-First-five-rows-in-a-straight-table/m-p/390811#M568420 <HTML><HEAD></HEAD><BODY><P>if u use qv11 then</P><P>dimension limits tab&nbsp; </P><P></P><P>check the check box and give ur required values</P><P></P><P>if u give 5 then it display upto top 5 values</P></BODY></HTML> Thu, 01 Nov 2012 09:38:17 GMT https://community.qlik.com/t5/QlikView/How-to-get-First-five-rows-in-a-straight-table/m-p/390811#M568420 2012-11-01T09:38:17Z Re: How to get First five rows in a straight table??? https://community.qlik.com/t5/QlikView/How-to-get-First-five-rows-in-a-straight-table/m-p/390812#M568421 <HTML><HEAD></HEAD><BODY><P>oh yeah Both of your answers are working <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />..Thank you..!!</P></BODY></HTML> Thu, 01 Nov 2012 09:42:37 GMT https://community.qlik.com/t5/QlikView/How-to-get-First-five-rows-in-a-straight-table/m-p/390812#M568421 2012-11-01T09:42:37Z