topic Re: Fetch time from timestamp in QlikView

Fetch time from timestamp

Mon, 26 Jan 2015 05:18:42 GMT

Hi everyone,

I am new to qlikview.I have timestamp value in field as '17-11-2014-00h:42m:21s'

i want to remove the date as well as h,m,s from the time value and only display '42:21'

Thanking u guys in advance.

Re: Fetch time from timestamp

PrashantSangle — Mon, 26 Jan 2015 05:31:39 GMT

Hi,

Try like

timestamp(timestamp#(purgechar(datefield,'hms'),'DD-MM-YYYY-hh:mm:ss'),'mm:ss')

time(timestamp#(purgechar(datefield,'hms'),'DD-MM-YYYY-hh:mm:ss'),'mm:ss')

If you required hours also then add "hh" in timestamp() and time()

Regards

Re: Fetch time from timestamp

anbu1984 — Mon, 26 Jan 2015 05:51:15 GMT

=Replace(TextBetween('17-11-2014-00h:42m:21s',':','s'),'m','')

Re: Fetch time from timestamp

MarcoWedel — Mon, 26 Jan 2015 07:31:48 GMT

One small suggestion to your solution:

time(frac(timestamp#(purgechar(datefield,'hms'),'DD-MM-YYYY-hh:mm:ss')),'mm:ss')

This way the resulting time value will be independent from the date part, e.g. using the time as dimension would only create one row per time.

Hope this helps

Regards

Marco

Re: Fetch time from timestamp

Mon, 26 Jan 2015 09:20:52 GMT

What if i want to make it as a field tht contains all the values

i tried in the edit script 'time(frac(timestamp#(purgechar(datefield,'hms'),'DD-MM-YYYY-hh:mm:ss')),'mm:ss') as Time' but the time field wont show any values.

Re: Fetch time from timestamp

PrashantSangle — Mon, 26 Jan 2015 15:05:49 GMT

Hi,

timestamp(timestamp#(purgechar(datefield,'hms'),'DD-MM-YYYY-hh:mm:ss'),'DD-MM-YYYY-hh:mm:ss')

Regards