Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Function for estimating the number of values

Short answer


Count(DISTINCT Field)

qumniusomnius
New Contributor III

Re: Function for estimating the number of values

Count(DISTINCT FieldName)

qlikmsg4u
Valued Contributor

Re: Function for estimating the number of values

=Count(Distinct Field)

Not applicable

Re: Function for estimating the number of values

Sunny, great, thanks!

Not applicable

Re: Function for estimating the number of values

Borja, thanks!

Not applicable

Re: Function for estimating the number of values

K N, than you!

Re: Function for estimating the number of values

No problem at all

Not applicable

Re: Function for estimating the number of values

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

Re: Function for estimating the number of values

Try this:

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