3 Replies Latest reply: Sep 11, 2015 7:01 AM by Anil kumar RSS

    rowno() and recno()

      Hi,

      Please explain...

      rowno() and recno()


        • Re: rowno() and recno()
          Sunil Chauhan

          Pasted from help

           

           

          RecNo( )

          Returns an integer for the number of the currently read row of the internal table. The first record is number 1.

           

          RowNo( )

          Returns an integer for the position of the current row in the resulting QlikView internal table. In contrast to RecNo( ), which counts the records in the raw data table, the RowNo( ) function does not count records that are excluded by where clauses and is not reset when a raw data table is Concatenation to another. The first row is number 1.

          Examples:

          Raw data tables:

          Tab1.csv

           

          A

          B

          1

          aa

          2

          cc

          3

          ee

           

          Tab2.csv

           

          A

          B

          5

          xx

          4

          yy

          6

          zz

           

          QVTab:

          Load *, RecNo( ), RowNo( ) from Tab1.csv where A<>2;

          Load *, RecNo( ), RowNo( ) from Tab2.csv where A<>5;

          The resulting QlikView internal table:

          QVTab

           

           

           

          A

          B

          RecNo( )

          RowNo( )

          1

          aa

          1

          1

          3

          ee

          3

          2

          4

          yy

          2

          3

          6

          zz

          3

          4

           

          hope this helps

          • Re: rowno() and recno()

            When used in your load script, when loading a table, RecNo() predictably returns the integer sequential row number of the input table... your source table of the load.  This counter gets reset every time you do a Load.  In contrast, RowNo() returns the position of the row in the table after the load.  So RowNo() is a sequential counter number for the rows in the table after it is loaded, 1, 2, 3, ...n.

             

            RowNo() is also a Chart function, so you can use it in an expression to return the sequential row number (starts at 1) for the current veritical dimension.  Or use RowNo(total) to get the overall sequential number.