topic Re: Count If in QlikView

Count If

Mon, 09 Jul 2012 08:25:23 GMT

Hi Experts,

I am trying to do a count where the values must be in a specific range.

My first count to check whether my load is less than a Ton works perfectly:

Num(Count ({< CYEAR = {'2012'}, Load = {"<1000"} >} DISTINCT LineNumber),'# ##0')

I now need to count where my load is between 1001 and 3000 and then another that is 3001 to 5000.

Can you please assist in telling me how to add some kind of an If statement into it.?

Thanks in Advance!

Wynand.

vincent_ardiet — Mon, 09 Jul 2012 08:57:42 GMT

Hi,

Try with :

Num(Count ({< CYEAR = {'2012'}, Load = {">1000<=3000"} >} DISTINCT LineNumber),'# ##0')

Regards,

Vincent

jagan — Mon, 09 Jul 2012 10:13:42 GMT

Hi,

Try like this

=Num(Count ({< CYEAR = {'2012'}, Load = {">=1000<=3000"} + {">=3001<=5000"} >} DISTINCT LineNumber),'# ##0')

Hope this helps you.

Regards,

Jagan.