Issues while trying to assign values to variables

[#1]

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 !

[#2 · Accepted solution]

Hi,

set 'CreationDate' in apostrophe.

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

Hope that is what you need to do.

Good luck!

Rainer

[#3]

Thanks a lot 🙂

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

Thank you very much !