topic Compare timestamp time with string in QlikView

Compare timestamp time with string

Thu, 14 Apr 2011 15:10:22 GMT

Hi,

I want to do something like this:

=if(Time([Order Lowest Object Date/Time],'hhmm')<1400,'Smaller','Bigger')

Whatever the [Order Lowest Object Date/Time] is, it does not get the result I want.

i.e. (01/12/2009) 1300 < 1400

It always says 'Bigger' (unless I replace 1400 by 0)

Any ideas?

Kind regards,

Maarten

gandalfgray — Thu, 14 Apr 2011 15:25:08 GMT

try

=if(hour([Order Lowest Object Date/Time])<14,'Smaller','Bigger')

erichshiino — Thu, 14 Apr 2011 15:25:24 GMT

Hi, Maarten

The time function will only format your number. The actual number behind it is basically the same.

The if syntax will use the full number behind it, despite number format.

In your case, I would tranform the [Order Lowest Object Date/Time] to a number to compare it with 1400.

It would be something like this?

if( hour([Order Lowest Object Date/Time])*100+minute([Order Lowest Object Date/Time])<1400, 'Smaller','Bigger')

Regards,

Erich

Thu, 14 Apr 2011 15:41:29 GMT

Thanks guys!

Exellent soltions! Work perfectly!