Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Function for estimating the number of values

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

14 Replies
sunny_talwar

Short answer


Count(DISTINCT Field)

qumniusomnius
Contributor III
Contributor III

Count(DISTINCT FieldName)

qlikmsg4u
Specialist
Specialist

=Count(Distinct Field)

Not applicable
Author

Sunny, great, thanks!

Not applicable
Author

Borja, thanks!

Not applicable
Author

K N, than you!

sunny_talwar

No problem at all

Not applicable
Author

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))