1 Reply Latest reply: Dec 21, 2014 3:55 AM by Anand Chouhan RSS

    The number of rows in a particular column of Qlikview

      What is  The number of rows in a particular column of Qlikview and How does it work??

        • Re: The number of rows in a particular column of Qlikview
          Anand Chouhan

          Hi,

           

          As i am understand your question Row of particular column means how many rows loaded in the current field that is by function we get also Rowno(). If you use this in any load statement as well as. Let assume this example

           

          LOAD *,RowNo() as Rid;

          LOAD * Inline

          [

          Field1,Field2,Field3

          A,8562,983

          B,,258

          B,267,523

          C,462,

          D,369,136

          ];

           

          And if you plot this fields in any table box

          Rid.png

          And if you use the system fields in the qlikview and plot that fields in any table box

          sysfields.png

          Hope this helps

          Regards

          Anand