4 Replies Latest reply: Nov 1, 2012 5:42 AM by darkyabc RSS

    How to get First five rows in a straight table???

      Hi Qlikies,

       

      I am new to Qlikview.. My purpose here is to get top 5 rows in a straight table..

      Actually if we do like this in edit script we'll get a new field right?

       

      SELECT TOP 5 * FROM TABLENAME;

       

      but thats not the thing I want.

      For example the following is a straight table..

       

      Header 1Header 2
      sai5236
      anu7410
      sbndjkh5263
      nkhk8846
      Harish54645
      jhbyjhg548464
      bhbvhbh534564
      mvbhjvghk55343
      bhbh5354
      nmbjbjk53153

       

       

      So here I want Details only upto Harish...for that what expression we have to use??

      Or what we have to do??

       

      Thank you all...Please Help and do reply

       

      Soon reply is appreciated..