topic Re: compare time in QlikView

compare time

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a list of time and want to know if they are in the future or past compare to now.

so expecting to see:

any idea, I tied to play with the interval function but not sucess yet...

Thanks

Raphael

LOAD * INLINE [

MyTime

01:00

05:00

10:00

15:00

20:00

];

Re: compare time

sergio0592 — Mon, 16 Jul 2018 09:53:27 GMT

Hi,

Use as expression :

if(time#(MyTime,'HH:MM:SS')<time(Now()),'Past','Future')

See the attached .qvw.

Regards

Re: compare time

tresB — Mon, 16 Jul 2018 09:55:00 GMT

Try:

If(MyTime>=Frac(Now()), 'Future', 'Past')

Re: compare time

Anonymous — Mon, 16 Jul 2018 09:55:00 GMT

Many thanks!

Re: compare time

thevingo — Mon, 16 Jul 2018 12:24:44 GMT

Hi

I know its already answered, but the solution doesn't work for me. My solution is:

Load *, If(Diff>0, 'Future', 'Past') as Flag_TIME;

Load *, Num(MyTime)-num(Time(Now())) + Num(Today()) as Diff, Time(Now()) as Now;

LOAD * INLINE [

MyTime

01:00

05:00

10:00

15:00

20:00

];

The result is