topic count distinct rows in LOAD statement in QlikView

count distinct rows in LOAD statement

Thu, 09 Sep 2010 12:51:54 GMT

Hi,

in my table there are two columns: NDG and ACCOUNT_NR

maybe

NDG ACCOUNT_NR

1 23

1 56

2 78

2 79

2 65

I want my load statement result like

NDG ACCOUNT_NR POS

1 23 1

1 56 2

2 78 1

2 79 2

2 65 3

where POS=current pos of distinct (NDG, ACCOUNT_NR) .

How can I write my load statement?

Thanks!

hector — Thu, 09 Sep 2010 14:49:33 GMT

Hi, with previous() and peek() functions, I 've made this

at least i have 100% of match with your result

See the attachment

Rgds

suniljain — Thu, 09 Sep 2010 15:20:22 GMT

Load Count(NDG&'-'&ACCOUNT_NR) AS COUNT_id

FROM .............