topic Count unique values in QlikView

Count unique values

Sunil_Kenth — Wed, 24 Aug 2011 09:32:03 GMT

Hi,

I need some help with an expression.

How can i count the number of unique and not unique email addresses in my data. The email field is called EMAIL.

Thanks for your help.

Sunil

Count unique values

Wed, 24 Aug 2011 09:40:17 GMT

Hi,

use "Count" aggr function with "Distinct" for respective field.

-Jai

Re: Count unique values

its_anandrjs — Wed, 24 Aug 2011 09:40:29 GMT

Hi,

You want to count unique values so for that you need to count by =Count(Distinct EMAIL) which gives count of unique values. and for duplicate values you need to count how much time it is repeated like =Count( EMAIL).

Regards,

Anand

Count unique values

kaushiknsolanki — Wed, 24 Aug 2011 09:42:05 GMT

Hi,

Try count(distinct EMAIL) for unique Mail ID

and

Count(Email) for over all Mail ID

Regards,

Kaushik Solanki