topic Convert Dates in set analysis in QlikView

Convert Dates in set analysis

anuradhaa — Wed, 04 Mar 2015 06:41:31 GMT

Hi,

I want to get the date based on selection criteria,

so i want to get Max date based on select criteria,

i used below syntax

=($(=Max(OutDate)))

but it return numaric value like 0.00074441687344913

but i want it as 3/2/2015. please tell me how to do that.

Wed, 04 Mar 2015 06:47:23 GMT

date(($(=Max(OutDate))),'DD/MM/YYYY') or change the Number format to Date in the Properties

jagan — Wed, 04 Mar 2015 07:15:43 GMT

Hi,

I think it should return a date somewhere around 40000, not sure why you are getting this number, anyway try this

=Date(Max(OutDate), 'M/D/YYYY')

Hope this helps you.

Regards,

Jagan.

Wed, 04 Mar 2015 07:29:04 GMT

hi,

use Date(Max(OutDate), 'DD/MM/YYYY')

if its not giving date then send your date sample . something is wrong.

may be your OutDate is in text format so that max is not working properly.

Regards

Vimlesh