topic Re: How to parse a date/time field and use the time portion and date portion on a line chart? in App Development

How to parse a date/time field and use the time portion and date portion on a line chart?

Fri, 30 Dec 2016 18:45:48 GMT

We have a goal to use a line chart - time on the y axis and date on the x axis. The format of the field is MMDDYYY hh:mm:ss tt. So, the question is how to parse the field and use the time (example: 8:15 am) part and date (example 12/30/2016) part on the line chart.

Re: How to parse a date/time field and use the time portion and date portion on a line chart?

sunny_talwar — Fri, 30 Dec 2016 19:12:48 GMT

To extract date

Date(Floor(DateTimeField))

To extract time

Time(Frac(DateTimeField))

Re: How to parse a date/time field and use the time portion and date portion on a line chart?

MK_QSL — Fri, 30 Dec 2016 19:26:07 GMT

As stalwar1‌ replied, this is what you can use to get Date and Time from a DateTime Field.

Only issue is .. as you mentioned that your DateTime Field is in MMDDYYYY hh:mm:ss tt ( I am assuming that you forgot one Y while mentioning DateTime format).. your TimestampFormat must be defined same.

SET TimestampFormat='MMDDYYYY hh:mm:ss TT';

If this is not the case, you have to use Interpretation and Formatting functions.

Date(Floor(TimeStamp#(DateTimeField,'MMDDYYYY hh:mm:ss TT'))) as Date

Time(Frac(TimeStamp#(DateTimeField,'MMDDYYYY hh:mm:ss TT'))) as Time

Please go through below link which will give you knowledge of these functions as well as how to get Date and Time field from DateTime.

Primer for QlikView Date fields

Happy Qliking.

Regards,