Solved: Separate date and time - Qlik Community

realpixel · ‎2013-10-16

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

CELAMBARASAN · ‎2013-10-16

You can use

Date(Floor(DateFeld)) AS Date

Time(Frac(DateField)) AS Time

tresesco · ‎2013-10-16

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

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

martinpohl · ‎2013-10-16

hello Pascal,

see attached

Regards

CELAMBARASAN · ‎2013-10-16

You can use

Date(Floor(DateFeld)) AS Date

Time(Frac(DateField)) AS Time

realpixel · ‎2013-10-16

Thank you Celambarasan, it's working perfectly!

Separate date and time