topic Re: Count and Serialize the duplicated value in QlikView

Count and Serialize the duplicated value

atsushi_saijo — Thu, 15 Jan 2015 09:09:14 GMT

In a request, we have to count and serialize the duplicated values in such manner (see Col2):

Col1	Col2
a	1
b	1
a	2
a	3
c	1

Here, we have 3 duplicated rows in Col1. User's request is to count gradually as loading script goes. Perhaps it's like comparing value with Previous(Col1), and if so, sum....How could we achieve such count?

*To obtain the total duplicated count, it is rather easy to group by and count Col1. But if we had to count as loading script goes, I wonder what could be the possibility?

Re: Count and Serialize the duplicated value

Gysbert_Wassenaar — Thu, 15 Jan 2015 09:13:08 GMT

LOAD

Col1,

autonumber(recno(),Col1) as Col2

FROM ...

Re: Count and Serialize the duplicated value

atsushi_saijo — Thu, 15 Jan 2015 09:19:35 GMT

Thank you for excellent and fast reply. It is verified working.