topic Re: What is wrong with this expression? in QlikView

What is wrong with this expression?

hopkinsc — Wed, 28 May 2014 13:06:37 GMT

Hi all, i have attached a sample file where i am getting an issue with an expression.

The expression should be summing the OrderComplete_Flag where the [Time Taken to Complete] is less than 4hrs.

the result i get should be 3 but i am getting 6 and i am unsure on why.

the expression is saying that 3 of the times are less than 4 hrs but they are not.

Can anyone help please?

Wed, 28 May 2014 13:12:45 GMT

=sum(if(Interval([Time Taken to Complete],'hhh')>=4,1,0))

hopkinsc — Wed, 28 May 2014 13:31:56 GMT

Hi, Sorry, i have just noticed that your expression says greater or equal to 4. i need it less than 4 but when i do that i get the wrong result.

Wed, 28 May 2014 13:41:06 GMT

=sum(if(SubField([Time Taken to Complete],':',1)<4,1,0))

hopkinsc — Wed, 28 May 2014 13:51:43 GMT

thats great thanks very much..

One more question,

how would i get a time range in there?

it is currently set at <4 hrs, but what if i wanted >1hr <24hrs?

Wed, 28 May 2014 13:54:25 GMT

=sum(if(SubField([Time Taken to Complete],':',1)>1 AND SubField([Time Taken to Complete],':',1)<24,1,0))