FielValueCount - What is it?

[alextomlins]

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

[YoussefBelloum]

Hi,

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

[jonathandienst · Accepted solution]

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]

ooh.. Thank a lot for these clarifications jontydkpi

[alextomlins]

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]

here is the explanation of this, read it carefully:

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