topic Re: Timestamp format help in QlikView

Timestamp format help

vvvvvvizard — Mon, 27 Jul 2015 09:58:28 GMT

Attaches is the excel sheet with the timestamp

Am trying to create a field that displays the timestamp , it must appear in charts and graphs as DD/MM/YYYYY hh:mm:ss tt format (not the number format )

another field which just shows DD/MM/YYYY hh:mm only (floor get the minutes , 9:45:35 , 9:45:12 must both show as 9:45)

one that shows the Hour only , so 9:00 , 10:00 : 11:00 14:00 ect (floor to get the hour , so 9:01 9:54 must show as 9:00

one that shows the DD/MM/YYYY only

Re: Timestamp format help

SatyaPaleti — Mon, 27 Jul 2015 10:02:24 GMT

Hi Yousuf,

Look into following link

Alt function

This Might helpful

Thank you,

SatyaPaleti

Re: Timestamp format help

sunny_talwar — Mon, 27 Jul 2015 10:03:44 GMT

This?

Script:

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/DD/YYYY';

SET TimestampFormat='M/DD/YYYY h:mm:ss[.fff] TT';

Table:

LOAD Timestamp,

Time(Frac(Timestamp)) as Time,

Date(Floor(Timestamp)) as Date

FROM

Community_174113.xlsx

(ooxml, embedded labels, table is Sheet1);

Re: Timestamp format help

PrashantSangle — Mon, 27 Jul 2015 10:05:43 GMT

Hi,

use Date()

try like

1) Date(YourField,'DD/MM/YYYY hh:mm:ss')

2) Date(YourField,'DD/MM/YYYY hh:mm')

3) Hour(YourField)

4) Date(YourField,'DD/MM/YYYY')

Regards

Re: Timestamp format help

sunny_talwar — Mon, 27 Jul 2015 10:11:18 GMT

Or this:

Script:

Table:

LOAD Timestamp,

TimeStamp(Timestamp, 'DD/MM/YYYY hh:mm') as Timestamp1,

Time(Time#(Floor(Frac(Timestamp) * 60 * 60/150), 'hh'), 'hh:mm') as Time,

Date(Floor(Timestamp), 'DD/MM/YYYY') as Date

FROM

Community_174113.xlsx

(ooxml, embedded labels, table is Sheet1);