topic Issues while trying to assign values to variables in QlikView

Issues while trying to assign values to variables

Mon, 08 Mar 2010 17:54:50 GMT

Hello all of you,

I've a minor issue in one of my QV dashboard.
I load several data from the Mantis Bug Tracker.

I have several dates so i would like, in the load script to assign to a variable the maximum value.

My code is similar to this one:


Anomalies:
LOAD
 ID,
 AssignedTo,
 Reporter,
 Priority,
 ....,
 CreationDate
FROM [MyFile.csv];

Dates:
LOAD DISTINCT CreationDate
RESIDENT Anomalies
ORDER BY CreationDate DESC;

LET vDateSoumissionMax = peek(CreationDate,0,'Dates');

Anyway, the "vDateSoumissionMax" is not created....

Can anyone help me?

Thanks a lot !

Issues while trying to assign values to variables

Mon, 08 Mar 2010 18:04:40 GMT

Hi,

set 'CreationDate' in apostrophe.

LET vDateSoumissionMax = peek('CreationDate',0,'Dates');

Hope that is what you need to do.

Good luck!

Rainer

Issues while trying to assign values to variables

Tue, 09 Mar 2010 08:39:56 GMT

Thanks a lot 🙂

It's working now... I've thought about putting 'dates' in apostrophe but not CreationDate

Thank you very much !