Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

alextomlins
New Contributor II

FielValueCount - What is it?

Hi Guys,

We have a contractor and in the master calendar he uses field value count. I have tried to look at the documentation but i couldn't make sense of it.

I guess i just wanted to ask how it works. He put it in because he was using an interval match function.

Anyone know a clear way of understanding what this does?

Thanks,

Alex

1 Solution

Accepted Solutions
MVP
MVP

Re: FielValueCount - What is it?

A bit more than that. It is not counting the distinct values in the data table, its actually counting the number of symbols for that field name in the symbol table.

This has two important results:

  • It is a lot faster than a count(distinct ...)) on a larger table
  • It counts symbols key fields in all tables that contain the key (unlike a Count in the load script)

Symbol Tables and Bit-Stuffed Pointers

5 Replies
YoussefBelloum
Esteemed Contributor

Re: FielValueCount - What is it?

Hi,

it return the distinct values of a field, just like a count(distinct..

MVP
MVP

Re: FielValueCount - What is it?

A bit more than that. It is not counting the distinct values in the data table, its actually counting the number of symbols for that field name in the symbol table.

This has two important results:

  • It is a lot faster than a count(distinct ...)) on a larger table
  • It counts symbols key fields in all tables that contain the key (unlike a Count in the load script)

Symbol Tables and Bit-Stuffed Pointers

YoussefBelloum
Esteemed Contributor

Re: FielValueCount - What is it?

ooh.. Thank a lot for these clarifications jontydkpi

alextomlins
New Contributor II

Re: FielValueCount - What is it?

What about this - What is it used for here? What is this doing?

  Floor(Min(Fieldvalue('AddedDateTime',RecNo()))) as _DateStart, 

            Floor(Max(Fieldvalue('AddedDateTime',RecNo()))) as _DateStop 

       AUTOGENERATE FieldValueCount('AddedDateTime')

YoussefBelloum
Esteemed Contributor

Re: FielValueCount - What is it?

here is the explanation of this, read it carefully:

“Fastest” Method to Read max(field) From a QVD | Qlikview Cookbook

Community Browser