topic how to use a viarable to receive a field value in QlikView

how to use a viarable to receive a field value

Fri, 13 Apr 2012 09:30:31 GMT

run the following script ,I get xx.qvd;

what's wrong with it ?

test:

load *;

select 2 as a,4 as b;

Concatenate

select 3 as a,5 as b;

let xx=max(FieldValue( 'a', 1 ));

let yy=max(FieldValue( 'b', 1 ));

if xx<yy then

store test into yy.qvd;

ELSE

store test into xx.qvd;

ENDIF;

how to use a viarable to receive a field value

CELAMBARASAN — Fri, 13 Apr 2012 09:42:30 GMT

Hi,

You should not use max for assigning to the variables.

Change it like this

let xx=FieldValue( 'a', 1 );

let yy=FieldValue( 'b', 1 );

how to use a viarable to receive a field value

CELAMBARASAN — Fri, 13 Apr 2012 09:45:43 GMT

Hi,

If you need max and minimum value you need to do like this.

test:

LOAD 2 as a,4 as b AutoGenerate 1;

Concatenate

Load 3 as a,5 as b AutoGenerate 1;

tempMax:

Load Max(a) as Maxa,Max(b) as Maxb Resident test;

let xx=FieldValue( 'Maxa', 1 );

let yy=FieldValue( 'Maxb', 1 );

Drop table tempMax;

if xx<yy then

store test into yy.qvd;

ELSE

store test into xx.qvd;

ENDIF;

Celambarasan

how to use a viarable to receive a field value

Jason_Michaelides — Fri, 13 Apr 2012 09:46:16 GMT

Also, you may need to call your variables with $...

test:

load *;

select 2 as a,4 as b;

Concatenate

select 3 as a,5 as b;

let xx=max(FieldValue( 'a', 1 ));

let yy=max(FieldValue( 'b', 1 ));

if $(xx)<$(yy) then

store test into yy.qvd;

ELSE

store test into xx.qvd;

ENDIF;

Hope this helps,

Jason

how to use a viarable to receive a field value

Fri, 13 Apr 2012 10:11:24 GMT

Thanks all