topic Re: Max date problem in QlikView

Max date problem

Wed, 29 May 2013 03:28:33 GMT

Hi All,

I have a date timestamp field, called "Creation Timestamp.History" , which I'd like to get the Max per Order Number.

I've used the expression : max([Creation Timestamp.History]), BUT it returns no values.

It should return : 03/08/2012 12:46:31 , in my attached example.

I'm not sure if it's just an issue with Timestamps, but I'm definitely doing something wrong?

Any tips?

Cheers!

Wed, 29 May 2013 04:16:45 GMT

Creation Timestamp.History is not in date format, its in character format

first create the date by using left, right and makedate function.... then it will work

Wed, 29 May 2013 04:24:01 GMT

Hi,

Please use the below Expression in the Chart .

max(Timestamp( Timestamp#([Creation Timestamp.History] , 'DD/MM/YYYY hh:mm:ss' ) ,'DD/MM/YYYY hh:mm:ss' ))

Regards

Yusuf

Wed, 29 May 2013 05:31:40 GMT

try this

max(date([Creation Timestamp.History],'DD/MM/YYYY hh:mm:ss'))

Wed, 29 May 2013 07:35:57 GMT

Thank you all for your feedback