Discussion board where members can get started with Qlik Sense.
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?
Go to 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:
Symbol Tables and Bit-Stuffed Pointers
it return the distinct values of a field, just like a count(distinct..
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
here is the explanation of this, read it carefully:
“Fastest” Method to Read max(field) From a QVD | Qlikview Cookbook