topic Re: How do I create a Record number field in an Inline load in QlikView

How do I create a Record number field in an Inline load

Thu, 20 Feb 2014 05:35:15 GMT

Hi All,

I am creating a dynamic inline table. The mock code of the Inline table is as below -

Let vRec = RowNo(); //RecNo()

For vStart = 1 to 10

Table:

LOAD Distinct * INLINE [

Start, RecNo

$(vStart), $(vRec) ];

NEXT vStart;

Somehow the RecNo() nor the RowNo() seems to give the record number for each record for the table.

Can you please suggest a way to achieve that?

Regards,

SK

Re: How do I create a Record number field in an Inline load

CELAMBARASAN — Thu, 20 Feb 2014 05:51:48 GMT

Try this simple script

For vStart = 1 to 10

Table:

LOAD Distinct *, RowNo() AS RecNo INLINE [

Start

$(vStart) ];

NEXT vStart;

Re: How do I create a Record number field in an Inline load

Siva_Sankar — Thu, 20 Feb 2014 05:53:48 GMT

Try these..

Let Rows=NoofRows(Table);

For vStart = 1 to 10

Table:

LOAD Distinct * INLINE [

Start, RecNo

$(vStart), $(Rows) ];

NEXT vStart;

Regards.

Siva

Re: How do I create a Record number field in an Inline load

Thu, 20 Feb 2014 06:04:03 GMT

Thanks a lot. Works perfectly..

Cheers,

SK