topic Do a group by using a rowno in QlikView

Do a group by using a rowno

Wed, 16 Jan 2013 10:59:39 GMT

Hi all ,

I'm trying to do something in QV .

The issue that i have a table like this .

ID1 ID2

1 1

1 23

1 2

2 43

6 64

1 8

2 55

6 77

6 80

what i want to have is :

ID1 ID2 Order

1 1 1

1 2 2

1 8 3

1 23 4

2 43 1

2 55 2

6 64 1

6 77 2

6 80 3

Thx

Re: Do a group by using a rowno

sujeetsingh — Wed, 16 Jan 2013 11:04:27 GMT

Didnt get you ?

Re: Do a group by using a rowno

swuehl — Wed, 16 Jan 2013 11:05:47 GMT

Maybe like this:

INPUT:

LOAD * INLINE [

ID1, ID2

1, 1

1, 23

1, 2

2, 43

6, 64

1, 8

2, 55

6, 77

6, 80

];

LOAD ID1,

ID2,

AutoNumber(ID2,ID1) as Order

Resident INPUT order by ID1, ID2;

drop table INPUT;

Re: Do a group by using a rowno

Wed, 16 Jan 2013 11:20:51 GMT

according to swuehl , see the attachement.

thanks swuehl.

Re: Do a group by using a rowno

Wed, 16 Jan 2013 13:19:52 GMT

ID2 seems to be sorted as String.

Try Num#(ID2) as ID2 in the load and sort afterwards.

Ciao

Klaus

Re: Do a group by using a rowno

Wed, 16 Jan 2013 14:44:46 GMT

Thanx everybody swuehl's solution is what i want .