topic Set analysis with >= and < in QlikView

Set analysis with >= and <

Thu, 13 Nov 2014 13:07:43 GMT

I am trying to make the below expression work but I am missing the portion that ATADiff should be less than 10

count({<Country={CA},CallStatusDesc={Dispatched},ATADiff = {">=1"}>}MemberID)

Basically am trying to attain 1 <= ATADiff < 10 using the above expression.

Pleas help.

Thank you,

Amit

jonathandienst — Thu, 13 Nov 2014 13:16:25 GMT

count({<Country={CA},CallStatusDesc={Dispatched},ATADiff = {">=1<10"}>}MemberID)

HTH

Jonathan

Thu, 13 Nov 2014 13:45:32 GMT

try this

count({<Country={CA},CallStatusDesc={Dispatched},ATADiff = {">=1<10"}>}MemberID)

Just give like this it will work fine

Thu, 13 Nov 2014 13:55:45 GMT

Thanks guys. I didn't know the answer was that simple.