topic Re: Separate date and time in QlikView

Separate date and time

realpixel — Wed, 16 Oct 2013 11:16:03 GMT

Hello,

I have following chart

How to separate the column date.

I need to have one column only for the date and another column for the time.

Someone have an idea, how to solve this problem?

date

17/07/2013 18:02

17/07/2013 18:03

17/07/2013 18:04

17/07/2013 18:17

17/07/2013 18:20

17/07/2013 18:21

17/07/2013 18:44

17/07/2013 18:45

17/07/2013 18:46

18/07/2013 06:35

18/07/2013 06:59

18/07/2013 07:00

18/07/2013 07:10

18/07/2013 07:14

18/07/2013 07:18

tresB — Wed, 16 Oct 2013 11:23:01 GMT

For date, try = Date(YourDateField, 'DD/MM/YYYY')

and for Time, =Time(TimeStamp#(YourDateField, 'DD/MM/YYYY hh:mm'), 'hh:mm')

martinpohl — Wed, 16 Oct 2013 11:23:19 GMT

hello Pascal,

see attached

Regards

CELAMBARASAN — Wed, 16 Oct 2013 11:32:41 GMT

You can use

Date(Floor(DateFeld)) AS Date

Time(Frac(DateField)) AS Time

realpixel — Wed, 16 Oct 2013 11:41:07 GMT

Thank you Celambarasan, it's working perfectly!