Count unique rows

[#1]

Hello all,

I want to create in qlikview  a expression which tell me about  the total webshop order. In the underneath picture of row R the total row is 17.  the correct row is actually 13. which expression should i use to count the unique rows?

Greets,

Rega

[sunny_talwar]

Try this:

Count(DISTINCT PostingReference)

[Chanty4u]

try

=Count(FieldName)     ---->  it will give total count.

=Count(Distinct FiledName)  ----- >it will give unique count.

[#4]

Hi Rega,

Try the Distinct function like Sunny has instructed.