Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
| |
12345 |
| |
12345 |
| |
12345 |
|
So guys, pls help
rgds
Jim
or should i just go the other way round? count the header2 ???? count(header2) will give me a result of 4.
Where do you want to display your result? In a text object if you use Count(record_id) it should give you 4.
in a pivot table. it gives me 1 when i use count(order_id)
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