topic Timestamp, Max() and set analysis in QlikView

Timestamp, Max() and set analysis

Anonymous — Sun, 18 Sep 2011 20:32:31 GMT

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

Timestamp, Max() and set analysis

swuehl — Sun, 18 Sep 2011 22:01:49 GMT

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

Re: Timestamp, Max() and set analysis

Anonymous — Mon, 19 Sep 2011 07:57:06 GMT

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

Re: Timestamp, Max() and set analysis

swuehl — Mon, 19 Sep 2011 09:12:44 GMT

Hi Sander,

try your expressions using quotes around the variable, like

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

Re: Timestamp, Max() and set analysis

Anonymous — Mon, 19 Sep 2011 09:21:38 GMT

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