topic Re: Explaination for FieldValue() & FieldValueCount() in QlikView

Explaination for FieldValue() & FieldValueCount()

Anonymous — Thu, 17 Dec 2015 05:27:40 GMT

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

Re: Explaination for FieldValue() & FieldValueCount()

settu_periasamy — Thu, 17 Dec 2015 05:57:14 GMT

This will also Help..

Missing Manual - FieldValue

Re: Explaination for FieldValue() & FieldValueCount()

Anonymous — Thu, 17 Dec 2015 06:08:15 GMT

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

Re: Explaination for FieldValue() & FieldValueCount()

Kushal_Chawda — Thu, 17 Dec 2015 06:25:00 GMT

see the below link

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

Re: Explaination for FieldValue() & FieldValueCount()

Anonymous — Thu, 17 Dec 2015 06:31:44 GMT

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