topic Changing hour/date format in QlikView

Changing hour/date format

Anonymous — Tue, 14 Feb 2012 19:58:49 GMT

Hello, I have this Time/Date cell:

I want to separate the date and the hour from the cell,

how can I do that using the script?

Thank you very much

Re: Changing hour/date format

Tue, 14 Feb 2012 23:49:13 GMT

Hi Juan,

you can do that using 3 functions: Date, Time, Floor

Date(floor(DateTimeField)) as [DateTimeField - Date],
Time(DateTimeField-floor(DateTimeField)) as [DateTimeField - Hour],

See the attached sample qvw.

Ingo.

Re: Changing hour/date format

Sokkorn — Wed, 15 Feb 2012 01:00:22 GMT

Hi Juan,

Try this simple

LOAD

DATE(DateField) AS [Dates],

TIME(DateField) AS [Times],

.....

FROM ....

Regards,

Sokkorn Cheav

Changing hour/date format

jagan — Wed, 15 Feb 2012 05:03:44 GMT

Hi,

You can get the Date and Time in separate fields in in Load Script as suggested by Sokkorn by using DATE() and TIME() methods instead of Calculated dimension. Calculated Dimensions leads to performance issues.

Hope this helps you.

Regards,

Jagan.