Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
Symbol Tables and Bit-Stuffed Pointers
Hi,
it return the distinct values of a field, just like a count(distinct..
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:
Symbol Tables and Bit-Stuffed Pointers
ooh.. Thank a lot for these clarifications jontydkpi
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')
here is the explanation of this, read it carefully:
“Fastest” Method to Read max(field) From a QVD | Qlikview Cookbook