Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
alextomlins
Contributor III
Contributor III

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
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

5 Replies
YoussefBelloum
Champion
Champion

Hi,

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

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
YoussefBelloum
Champion
Champion

ooh.. Thank a lot for these clarifications jontydkpi

alextomlins
Contributor III
Contributor III
Author

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

here is the explanation of this, read it carefully:

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