topic Re: Set analysis: error in expression in QlikView

Set analysis: error in expression

Mon, 01 Feb 2016 12:30:03 GMT

Hello All,

I am using the expression below to get the count of calls which where hanged up between 1 to 5 seconds :

=Count({<WaitDuration={'>=1'}, WaitDuration={'<=5'}>}IF(

(timeFROMbegin>=begin1 and timeFROMbegin<=end1)

(timeFROMbegin>=begin2 and timeFROMbegin<=end2)

(timeFROMbegin>=begin3 and timeFROMbegin<=end3)

(timeFROMbegin>=begin4 and timeFROMbegin<=end4)

(timeFROMbegin>=begin5 and timeFROMbegin<=end5)

(timeFROMbegin>=begin6 and timeFROMbegin<=end6)

(timeFROMbegin>=begin7 and timeFROMbegin<=end7)

(timeFROMbegin>=begin8 and timeFROMbegin<=end8)

(timeFROMbegin>=begin9 and timeFROMbegin<=end9)

(timeFROMbegin>=begin10 and timeFROMbegin<=end10)

(timeFROMbegin>=begin11 and timeFROMbegin<=end11)

(timeFROMbegin>=begin12 and timeFROMbegin<=end12)

(timeFROMbegin>=begin13 and timeFROMbegin<=end13)

(timeFROMbegin>=begin14 and timeFROMbegin<=end14)

,ID))

I am got a wrong figure.

Any idea on how to correct the formula.

Many Thanks,

Hasvine

Re: Set analysis: error in expression

sunny_talwar — Mon, 01 Feb 2016 12:33:02 GMT

Not sure if this will make a difference in the output, but try this:

=Count({<WaitDuration={'>=1<=5'}>} If(

(timeFROMbegin>=begin1 and timeFROMbegin<=end1)

(timeFROMbegin>=begin2 and timeFROMbegin<=end2)

(timeFROMbegin>=begin3 and timeFROMbegin<=end3)

(timeFROMbegin>=begin4 and timeFROMbegin<=end4)

(timeFROMbegin>=begin5 and timeFROMbegin<=end5)

(timeFROMbegin>=begin6 and timeFROMbegin<=end6)

(timeFROMbegin>=begin7 and timeFROMbegin<=end7)

(timeFROMbegin>=begin8 and timeFROMbegin<=end8)

(timeFROMbegin>=begin9 and timeFROMbegin<=end9)

(timeFROMbegin>=begin10 and timeFROMbegin<=end10)

(timeFROMbegin>=begin11 and timeFROMbegin<=end11)

(timeFROMbegin>=begin12 and timeFROMbegin<=end12)

(timeFROMbegin>=begin13 and timeFROMbegin<=end13)

(timeFROMbegin>=begin14 and timeFROMbegin<=end14)

,ID))

Re: Set analysis: error in expression

Mon, 01 Feb 2016 12:36:50 GMT

Thanks for your help Sunny. 🙂

KR,

Hasvine

Re: Set analysis: error in expression

tresB — Mon, 01 Feb 2016 12:40:24 GMT

When you use same field reference more than once in set analysis it takes the first reference into calculation, so when you use ({<WaitDuration={'>=1'}, WaitDuration={'<=5'}>} , the expression would actually take the first reference (i.e - {<WaitDuration={'>=1'} ) and would get result accordingly. The solution is suggested by Sunny T above.