topic Re: Compare Time between date and stored time in variable in QlikView

Compare Time between date and stored time in variable

Fri, 07 Jun 2013 09:18:48 GMT

Hello Friends,

I want to compare time between time of date and time in variable. But in calculation if always gives me wrong result.

please see below example.

Ex.

DT1	Time of DT1	Variable (p_time = '10:30')	Expected Result
27/05/2013 08:00:00	08:00	10:30	1
24/05/2013 08:30:00	08:30	10:30	1
24/05/2013 09:00:00	09:00	10:30	1
26/05/2013 10:40:00	10:40	10:30	0
26/05/2013 11:00:00	11:00	10:30	0

here in this example according to formula my result should be "Expected Result" but it always give me wrong result.

I have attached this examle file as well.

Please help me to identify the problem.

Thanks

Sokkorn — Fri, 07 Jun 2013 09:29:41 GMT

Hi dipak.nit,

1. Change your variable: p_time = Interval('10:00','hh:mm')

2. Compare expression should be like this

=If(Interval#(Time(DT1,'hh:mm'),'hh:mm') <= p_time, '1','0')

Regards,

Sokkorn

Fri, 07 Jun 2013 09:32:40 GMT

Hi Sokkorn,

It is working now.

Thank you.

Fri, 21 Aug 2015 03:26:22 GMT

Hi b. Sokkorn,

It's also solve my problem (y)

Thank you.