topic Autonumber in expression in QlikView

Autonumber in expression

Mon, 05 Mar 2012 14:51:28 GMT

Hi All,

within an expression I need to autonumerate rows in a way that new Name restarts counter

Name, Number

John, 1

John, 2

Mary, 1

John, 3

Mary, 2

Any idea?

Regards,

Przemek

Mon, 05 Mar 2012 15:17:20 GMT

Hi,

use the example code below

Temp1:

LOAD * INLINE [

name

John

Mary

John

Mary

];

Regards

Przemek

Tab:

NoConcatenate

LOAD

name,

IF (peek('name')<>name,1, peek('counter')+1) AS counter

RESIDENT Temp1

order by name;

drop table Temp1;

Mon, 05 Mar 2012 15:21:32 GMT

Hi Przemek 🙂

thanks for the reply. The problem, however, is that I need to have it built within an expression not script.

Regards,

Przemek

Mon, 05 Mar 2012 15:25:51 GMT

You could use similar approach, however that would only work when the names are sorted.

I can't think of a possible workaround at the moment (without having the names sorted).

Regards

Przemek