topic Need unique id for each record in QlikView

Need unique id for each record

Fri, 18 Nov 2011 07:26:33 GMT

Hi All,

I need unique id for each record in year field.

Eg:

Year ID

2009 - 2010 1

2010 - 2011 2

2011 - 2012 3

Can any one help me.

Thanks,

Antony.

Need unique id for each record

SunilChauhan — Fri, 18 Nov 2011 07:59:27 GMT

can you be more specific with your requirement.

as u already have unique id.

Need unique id for each record

Fri, 18 Nov 2011 08:09:38 GMT

Hi,

Try with autonumber function

autonumber (expression[ , AutoID] )

Hope this will help you.

Thanks & Regards

Upendra

Need unique id for each record

Fri, 18 Nov 2011 08:12:14 GMT

II think Antony with the picture illustrates how he wants it to look like.

Try function:

rowno().

Load Year,

rowno() as ID;

FROM ......

/Danne

Need unique id for each record

Fri, 18 Nov 2011 08:49:16 GMT

I tried by autonumber an Rowno() but its not coming....

Need unique id for each record

Fri, 18 Nov 2011 08:50:10 GMT

Hi Sunil,

I have given an example on above....

Need unique id for each record

Fri, 18 Nov 2011 08:51:13 GMT

Hi Upendra/Danne,

Can you send an example application.

Re: Need unique id for each record

Fri, 18 Nov 2011 09:17:16 GMT

This should work:

LOAD RowNo() as ID,

Num(Year(CREATED),'00','####') as Year;

SQL SELECT *

FROM Table X;

Need unique id for each record

Fri, 18 Nov 2011 09:24:44 GMT

Hi,

try with this:

LOAD

RecNo() as ID,

...

regards