Function for estimating the number of values

[#1]

I have a really short question!

Which function estimates the number of values in a field?

I do not care what is the sum or avg for value, I need only the number of unique values in a field.

Many thanks in advace!

Marina

[sunny_talwar]

Short answer

Count(DISTINCT Field)

[qumniusomnius]

Count(DISTINCT FieldName)

[qlikmsg4u]

=Count(Distinct Field)

[#5]

Sunny, great, thanks!

[#6]

Borja, thanks!

[#7]

K N, than you!

[sunny_talwar]

No problem at all

[#9]

Sunny,

I'm so sorry. I forgot to clarify that I need a function for estimating the number of only numeric valeus. Is it possible?

Marina

[sunny_talwar]

Try this:

Count(DISTINCT If(IsNum(Field), Field))