Timestamp, Max() and set analysis

[Anonymous]

Hi, in my script I define a variable as Max(Num(DATEFIELD)). And in a chart I use set analysis to show the values belonging to this max date. Now as long as I use a datefield without time-part (floor(DATEFIELD) this works fine. Now I need to use a full date+time DATEFIELD and somehow my set analysis doesn't match this date (and time) anymore. Although the variable gives me the correct max value to match with in the set analysis (40746,4937...)? Regards, Sander

[swuehl]

Hi Sander,

I remember I had a similar problem just recently, but don't know how I handled it right now, need to look up tomorrow.

Would it be possible for you to post a sample application here?

Regards,

Stefan

[Anonymous]

Hi Stefan, sure. Here it is. Can't get it to work. The variable shows no value... Regards, Sander

[swuehl · Accepted solution]

Hi Sander,

try your expressions using quotes around the variable, like

Sum({$<DATE={'$(vMaxiDateFull)'}>} ITEMA)

See also attached.

Stefan

[Anonymous]

Hi Stefan, life can be so easy. Thanks!

PS:

Also tried to leave out the equal sign in the SET command in the script. Then the variable uses the formula but then I can't find a working syntax for the set analysis/dollar sign expansion. Not that I need it now (since adding the quotes has done the trick) but as a general question in this case. Regards, Sander