topic Re: Date data type from excel file usinn max function in QlikView

Date data type from excel file usinn max function

Thu, 20 Sep 2012 09:02:39 GMT

i load date from excel file table.

when i use a MAX function on the Date column it return a number

only when i use Maxstring function it return the max Date .

why?

the column is define as a date in the excel file why i can not use MAX function ?

Anonymous — Thu, 20 Sep 2012 09:07:38 GMT

Hi sharon,

U nid to chk d excel format for d concerned field.

Regards,

Vaibhav

Thu, 20 Sep 2012 09:10:27 GMT

Sorry

didn't uderstand your answer

martinpohl — Thu, 20 Sep 2012 09:14:10 GMT

like in excel, too, QV stores a date or a timestamp as a number.

For that you can calculate them for example.

by using date(max(datefield,'MM/DD/YYYY') you will get the date shown as a date.

Regards

giakoum — Thu, 20 Sep 2012 09:14:44 GMT

QlikView does not identify that field to be a date. You need to expalin that to QlikView.

If you date format is 19.09.2012 for example, you need to set that command prior from loading :

SET DateFormat='DD.MM.YYYY';

Thu, 20 Sep 2012 09:17:55 GMT

Help a lot

it is working good

Thank you .

giakoum — Thu, 20 Sep 2012 09:23:27 GMT

Please close this disucssion by marking it as correctly answered.

Thank you.