Explaination for FieldValue() & FieldValueCount()

[Anonymous]

Hello Everyone,

Just need a simple explaination for following syntax:

let test=FieldValueCount('Call_Date');  //Counting distincting value of CallDate which is 99 in my case

Test:

load

min(FieldValue('Call_Date',RecNo()))-1 as MinDate,

max(FieldValue('Call_Date',RecNo())) as MaxDate

AutoGenerate FieldValueCount('Call_Date');

I have done some home work on both the fields and very much clear how FieldValueCount() works but still not able to interpret how FieldValue() fetching min & max value?

Please suggest how QV is working here with the combination of Fieldvalue() & Recno()...

Regards,

Balraj Ahlawat

[settu_periasamy]

This will also Help..

Missing Manual - FieldValue

[Anonymous]

These threads I have already checked but didnt get my answer..

[Kushal_Chawda]

see the below link

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

[Anonymous · Accepted solution]

Here is the interpretation:

load

(FieldValue('Call_Date',RecNo()))-1 as MinDate,

(FieldValue('Call_Date',RecNo())) as MaxDate

AutoGenerate FieldValueCount('Call_Date');

If I dont specify min() & max() it would iterate and autogenerate till the max value of FieldValueCount('Call_Date') and display all the records of min and max date.

And If I do this:

Test:

load

min(FieldValue('Call_Date',RecNo()))-1 as MinDate,

max(FieldValue('Call_Date',RecNo())) as MaxDate

AutoGenerate FieldValueCount('Call_Date');

It will iterate all the records internally but will give min and max date only at the end