topic Re: Compare time with string in QlikView

Compare time with string

Wed, 04 Nov 2015 09:01:12 GMT

Hello,

I make a sql query that gets an array of time values and I want to show only the values that are bigger than a specific value that I save on a string.

The value I save to a string it is another time value saved on my script.

The condition I have is:

=if(hour(sqlTimeArray)<=strTime,1,0)

But this condition does not work and shows all the values I have on the array.

Am I doing something wrong?

Thanks in advance.

Regards,

Ivo

Re: Compare time with string

Kushal_Chawda — Wed, 04 Nov 2015 09:13:08 GMT

what is format of sqlTimeArray & StrTime?

Re: Compare time with string

Wed, 04 Nov 2015 09:20:17 GMT

sqlTimeArray has time values, for example: 12:26:30

StrTime I formated has "time", so also in the same format, ex: 14:08:05

Re: Compare time with string

sasikanth — Wed, 04 Nov 2015 09:25:28 GMT

HI,

Try like this

hour(Date(Date#(time_string,'hh:mm:ss'),'hh:mm:ss'))

Re: Compare time with string

settu_periasamy — Wed, 04 Nov 2015 09:26:44 GMT

Hi,

Try Like

=if(hour(sqlTimeArray)<=hour(strTime),1,0)

if(Interval('sqlTimeArray','HH')<Interval('strTime','HH'),1,0)

Re: Compare time with string

Kushal_Chawda — Wed, 04 Nov 2015 09:46:00 GMT

try this

=if( interval(sqlTimeArray,'hh')<= interval(time#(strTime,'hh:mm:ss'),'hh'),1,0)

Re: Compare time with string

Wed, 04 Nov 2015 10:58:39 GMT

Apparently with this solution it works.

Thank you.

Re: Compare time with string

Kushal_Chawda — Wed, 04 Nov 2015 11:11:39 GMT

I am glad that it was helpful