topic Re: Use of the FieldValue function on several lines in QlikView

Use of the FieldValue function on several lines

Tue, 16 Dec 2014 17:04:13 GMT

Hello,

I just wrote the following code:

	Rows: NoConcatenate LOAD BUKRS, GJAHR, CPUDT Resident BKPF;
	DROP Table BKPF;

FOR i=1 to $(rows)

		SET BUKRS='';
		SET GJAHR = '';
		SET CPUDT = '';

		Trace i = $(i);
		Let BUKRS = FieldValue('BUKRS',$(i));
		Let GJAHR = FieldValue('GJAHR',$(i));
		Let CPUDT = Date(FieldValue('CPUDT',$(i)),'YYYYMMDD');
		Trace BUKRS = $(BUKRS) - GJAHR = $(GJAHR) - CPUDT = $(CPUDT);

In my example, there are three rows in my 'Rows' table. The trace function works fine with the first record, like this:

BUKRS = 1000 - GJAHR = 2014 - CPUDT = 20141214, but for the following records, it looks like this BUKRS = 1100 - GJAHR = - CPUDT = . Only the BUKRS variable is set, even though there are values for GJAHR and CPUDT in my 'Rows' table.

I've tried to look for solutions for the last hour, but I could not find any.

Thanks!

Re: Use of the FieldValue function on several lines

Tue, 16 Dec 2014 17:41:24 GMT

Hi,

Fieldvalue requires distinct values on every row, what does your data look like? This may be your issue

Joe

Re: Use of the FieldValue function on several lines

rwunderlich — Tue, 16 Dec 2014 19:10:23 GMT

As Joe pointed out, FieldValues() operates on values, not rows. If you want to process a table row-by-row use the peek() function.

-Rob

Re: Use of the FieldValue function on several lines

Wed, 17 Dec 2014 10:07:57 GMT

Hi,

Right, I did not understand the bit about distinct values in the help for FieldValue(). Thanks! GJAHR and CPUDT were indeed identical for the three records in my table.

The peek() function works just fine. Thanks again.