i need to count duplicate records, but qlik doesnt allow.

[jim_chan]

hi guys,

i have to count duplicate records, but qlik auto help me to distinct the the record id.

My end result is: i want the count is 4. instead of 1.

So when i use script - count(record_id) , it gives me back 1.

record_id	Header 2
12345	10AUG2018:15:37:33
12345	10AUG2018:15:47:43
12345	10AUG2018:15:57:50
12345	10AUG2018:16:37:03

So guys, pls help

rgds

Jim

[jim_chan]

or should i just go the other way round? count the header2 ???? count(header2) will give me a result of 4.

[vishsaggi]

Where do you want to display your result? In a text object if you use Count(record_id) it should give you 4.

[jim_chan]

in a pivot table. it gives me 1 when i use count(order_id)

[olivierrobin]

hello

what is the dimension of you pivot table ?

if it is order_id, count(order_id) will give 1

why don't you use count(distinct timestamp), and in this case, you will obtain 4