topic Re: maximum time in QlikView

maximum time

master_student — Fri, 23 Sep 2016 10:15:21 GMT

Hello everyone

please how to get the maximum time of a date field that has this format : 12/06/2013 12:33:55

Thanks in advance

Re: maximum time

Chanty4u — Fri, 23 Sep 2016 10:20:00 GMT

try

LOAD
*,
Date(Floor([Field])) AS [%Maxtime];

Re: maximum time

robert_mika — Fri, 23 Sep 2016 10:21:52 GMT

Try

max(time(yourfiled))

Re: maximum time

susovan — Fri, 23 Sep 2016 10:24:10 GMT

You can also try this below expression,

=Date#(Now())

Re: maximum time

master_student — Fri, 23 Sep 2016 10:29:55 GMT

it displays the date not the time. see bellow :

Re: maximum time

master_student — Fri, 23 Sep 2016 10:34:58 GMT

I don't need the maximum time in absolut. for example I had DATE_DEB that contains

12/01/2016 12:00:12

12/01/2016 08:00:12

12/01/2016 14:00:12

I need to get : 14:00:12

Re: maximum time

antoniotiman — Fri, 23 Sep 2016 10:35:04 GMT

Hi Wiem,

if You have more dates

12/06/2013 12:33:55
13/06/2014 12:20:40

Max(Time(Date)) -> 12:20:40
Time(Max(Frac(Date))) -> 12:33:55

Regards,

Antonio

Re: maximum time

Anonymous — Fri, 23 Sep 2016 10:36:13 GMT

=Max(Time(Your Date Field))

Hope it helps!!

Re: maximum time

master_student — Fri, 23 Sep 2016 10:37:13 GMT

didn't work in my case. see bellow :

Re: maximum time

master_student — Fri, 23 Sep 2016 10:40:34 GMT

I need the maximum time of only one date

Re: maximum time

Anonymous — Fri, 23 Sep 2016 10:44:43 GMT

Did you try my expression? It will work

Re: maximum time

master_student — Fri, 23 Sep 2016 10:46:05 GMT

no it didn't

Re: maximum time

Peter_Cammaert — Fri, 23 Sep 2016 10:48:45 GMT

Use only the date as dimension and Max(Time(DateTimeField)) as expression. Max() is an aggregation function to be used in a table expression.

You can wrap all identical dates together using a calculated dimension like: Date(Floor(DateTimeField))

Re: maximum time

Fri, 23 Sep 2016 10:49:44 GMT

Hi,

Do you want Max time of all the records in all fields??

try

max(time(total DATE_DEB)

HTH,

Abdul

Re: maximum time

Peter_Cammaert — Fri, 23 Sep 2016 10:49:44 GMT

You can't use Max() in calculated dimensions, at least not without aggr().

Re: maximum time

master_student — Fri, 23 Sep 2016 11:12:50 GMT

I need to set a condition in my expression to display the time only if it is >13:00:00 and <14:00:00

If(time(DATE_DEB)>'13:00:00', and time(DATE_DEB)>'13:00:00', '')

any idea please

Re: maximum time

susovan — Fri, 23 Sep 2016 11:14:17 GMT

Try this also,

=Time(Now())

Re: maximum time

MarcoWedel — Fri, 23 Sep 2016 23:24:33 GMT

please post some sample data and your expected result

thanks

regards

Marco

Re: maximum time

Anil_Babu_Samineni — Sat, 24 Sep 2016 09:28:43 GMT

I don;t think what you are expecting, here you are posting issue is different to now? Can you please post the sample application which demonstrates the expected o/p?

Anyway, try this

If you really have DATE_DEB has 12/06/2013 12:33:55 format, then might you will get below

Aggr(Date(Date#(If(Timestamp(Timestamp#(DATE_DEB,'DD/MM/YYYY hh:mm:ss'),'hh:mm:ss' > Timestamp(MakeTime(13:00:00),'hh:mm:ss') < Timestamp(MakeTime(14:00:00),'hh:mm:ss')), 'hh:mm:ss'),'DD/MM/YYYY hh:mm:ss'), DATE_DEB)