topic Re: Find Error in this expression in QlikView

Find Error in this expression

Fri, 09 May 2014 06:38:04 GMT

COUNT({<time((IN1-SHIFTSTARTTIME),'hh:mm:ss'){'<00:10:00'}>}PAYCODE)

IN1 ->field

SHIFTSTARTTIME ->Field

Paycode ->Field

hint:- {'<00:10:00'}

Re: Find Error in this expression

tresB — Fri, 09 May 2014 06:43:06 GMT

Set ananlysis is used where you can compare a script generated field value. Actually, nothing is right in your expression. You should have written it 'Find What is Right ....' . Please read set analysis from help.

Re: Find Error in this expression

Sat, 10 May 2014 06:59:26 GMT

=Count({<IN1={">$(=SHIFTSTARTTIME)"},time((IN1-SHIFTSTARTTIME),'hh:mm:ss')={"<$(=00:10:00)"}>}PAYCODE)

please I need help in this expresssion in Bar chart, how to apply this in an expression

error is coming in {"<$(=00:10:00)"}>} on this { . Please help

Re: Find Error in this expression

PrashantSangle — Sat, 10 May 2014 10:21:31 GMT

Hi,

I am not what you are looking for

But looking at your expression I thing you are comparing

Time Interval Between IN1 and SHIFTSTARTTIME which is less than 10:00 Mins.

So try like this,

=Count({<IN1={">$(=SHIFTSTARTTIME)"},Interval(IN1,SHIFTSTARTTIME,'hh:mm:ss')={"<$(=00:10:00)"}>}PAYCODE)

Regards,

Re: Find Error in this expression

swuehl — Sat, 10 May 2014 10:37:52 GMT

=count( if( (IN1-SHIFTSTARTTIME) < maketime(0,10), PAYCODE))

Re: Find Error in this expression

ToniKautto — Sat, 10 May 2014 11:14:58 GMT

This question look very much like two other threads you have posted. What makes this any different from the previous posts?

I need help with this expression

need help with this expression

Have you considered the implementation approach I have already suggested in need help with this expression ?