topic Re: time in QlikView

time

master_student — Fri, 23 Sep 2016 08:55:40 GMT

Hello,

I need to display time only if it is >= 13:00:00

If(TIME (DATE_DEB)>'13:00:00', TIME (DATE_DEB), '')

How to do it?

Thanks

sunny_talwar — Fri, 23 Sep 2016 08:59:06 GMT

May be this:

If(Time(DATE_DEB) > MakeTime(13), Time(DATE_DEB))

Digvijay_Singh — Fri, 23 Sep 2016 08:59:35 GMT

If(TIME (DATE_DEB)>13/24, TIME (DATE_DEB), '')

Chanty4u — Fri, 23 Sep 2016 09:00:39 GMT

try this

If(TIME (Field)>'13:00:00', TIME (Field),Time(Field)) as new

master_student — Fri, 23 Sep 2016 09:09:05 GMT

it didn't work sunny.

or how to get the maximum time of the DATE_DEB, I tried this exp : MAX (Time(DATE_DEB)), it didn't work

DATE_DEB has this '19/09/2016 13:00:00'

sunny_talwar — Fri, 23 Sep 2016 09:13:47 GMT

How about this:

If(Time(TimeStamp#(DATE_DEB, 'DD/MM/YYYY hh:mm:ss')) > MakeTime(13), Time(TimeStamp#(DATE_DEB, 'DD/MM/YYYY hh:mm:ss')))

master_student — Fri, 23 Sep 2016 09:18:06 GMT

nope. and the maximum time of the DATE_DEB field. any idea?

Thanks

sunny_talwar — Fri, 23 Sep 2016 09:19:51 GMT

In the script or front end? What are the dimensions?

tresB — Fri, 23 Sep 2016 09:21:20 GMT

Try like:

Time(MAX (Frac(DATE_DEB)), 'hh:mm:ss')

master_student — Fri, 23 Sep 2016 09:24:58 GMT

in the front end