topic Re: Problem with if statement and time comparison in QlikView

Problem with if statement and time comparison

Wed, 22 Apr 2015 07:30:08 GMT

Hello Everyone,

as usually i need your help

I've this if statement and i need it to create this dimension in a pivot or a listbox:

if(date(ACTION.TIME, 'hh:mm')<=date('14:30','hh:mm'),'Current Day','Following Days')

the date function recognize the hour and minutes and also the 14:30 for the right part but seems that qlik is not able to confront that.

Any suggestions?

Kind Regards,

Alfonso

Re: Problem with if statement and time comparison

datanibbler — Wed, 22 Apr 2015 07:36:16 GMT

Hi Alfonso,

try using the TIME function for that. I have that in several apps because we work in two shifts, with a changeover at 14:00 - it works for me in all cases. But there should be no need to wrap that '14:30' in any function as it's just a fixed value - your other function (around the ACTION.TIME) should return a value you can compare to that.

Try with the TIME function for a start.

HTH

Re: Problem with if statement and time comparison

PrashantSangle — Wed, 22 Apr 2015 07:37:30 GMT

Hi,

Try to convert it into number then compare.

or try below

if(time(ACTION.TIME, 'hh:mm')<=time(time#('14:30','hh:mm'),'hh:mm'),'Current Day','Following Days')

Regards

Re: Problem with if statement and time comparison

Gysbert_Wassenaar — Wed, 22 Apr 2015 07:38:02 GMT

date('14:30','hh:mm') won't work. The date() function only formats a date. It doesn't create a date from a string value. Try time#('14:30', 'hh:mm').

Re: Problem with if statement and time comparison

Frank_Hartmann — Wed, 22 Apr 2015 07:38:48 GMT

try this:

=if(date(time(ACTION.TIME, 'hh:mm'))<=date(time(('14:30'),'hh:mm')),'Current Day','Following Days')

Re: Problem with if statement and time comparison

Wed, 22 Apr 2015 08:14:49 GMT

Don't works too... can you try it before on similar data?

Re: Problem with if statement and time comparison

Wed, 22 Apr 2015 08:15:42 GMT

Don't works too... can you try it before on similar data?

Re: Problem with if statement and time comparison

Wed, 22 Apr 2015 08:16:13 GMT

Don't works too... can you try it before on similar data?

Re: Problem with if statement and time comparison

Wed, 22 Apr 2015 08:16:47 GMT

Don't works too... can you try it before on similar data?

Re: Problem with if statement and time comparison

anbu1984 — Wed, 22 Apr 2015 08:56:25 GMT

Can you post sample app

Re: Problem with if statement and time comparison

Wed, 22 Apr 2015 09:16:39 GMT

unfortunately not, but i can say that the problem is with right part... qlik is not able to recognize time#('14:30', 'hh:mm') like a time format

Re: Problem with if statement and time comparison

PrashantSangle — Wed, 22 Apr 2015 09:22:40 GMT

Hi,

Without sample apps it is difficult to provide solution.

but you can debug your own code, by taking each expression in text object

check below in text object

=time(ACTION.TIME, 'hh:mm')

time(time#('14:30','hh:mm'),'hh:mm')

if it wont work

try with NUM() and frac()

num(time(ACTION.TIME, 'hh:mm'))<= num(time(time#('14:30','hh:mm'),'hh:mm'))

do same with frac()

Regards