topic Variable Assignment in QlikView

Variable Assignment

Tue, 15 Jun 2010 08:26:07 GMT

Hi,

I want to assign the value generated from the below load statement in to a variable name as Rec, pls provide me the script to be written for acheiving these task

LOAD MAX(RECORD_NO) from TEST.QVD

Thanks,

Arun

Variable Assignment

Miguel_Angel_Baeyens — Tue, 15 Jun 2010 08:29:21 GMT

Hello Arun,

Rename first the field so you can use it later

LOAD MAX(RECORD_NO) AS MAX_RECORD from TEXT.QVD

I'm using the following

LET vMaxRecordNo = FieldValue('MAX_RECORD', 1);

Peek() or even LookUp() will do as well.

Regards.

Variable Assignment

Tue, 15 Jun 2010 08:31:28 GMT

Hi Arun,

here you are

DATA:
Load
Max(Reord_No) as MaxRecordNo
From Test.qvd (qvd);

Let vRec = Peek('MaxRecordNo', 0, 'DATA');

Good luck!

Rainer