topic Re: count if... in QlikView

count if...

anitamanders — Tue, 10 Sep 2013 12:18:30 GMT

Hello,

I have a pivot table with a column (1) that loads (sum sales - sum target)

Now I want to count all customernames where column (1) < 0 (so where sales < target)

I have tried this:

Count (DISTINCT(if(Column(1)= '<=0',[organisatie_naamorg])))

but this results in 0 for everything, so I am doing something wrong....

Can someone help me with this?

Thanks!

Re: count if...

tresB — Tue, 10 Sep 2013 12:25:08 GMT

Try: Column(1)<=0

instead of

Column(1)= '<=0'

Re: count if...

Tue, 10 Sep 2013 12:29:04 GMT

try this

Count (DISTINCT(if(Column(1)<=0,[organisatie_naamorg])))

Re: count if...

anitamanders — Tue, 10 Sep 2013 12:30:05 GMT

no, does not work

Re: count if...

Anonymous — Tue, 10 Sep 2013 12:36:47 GMT

Hi Anita,

Hope the attached file will helpful for you

Regards

Ashok

Re: count if...

narender123 — Tue, 10 Sep 2013 12:43:28 GMT

Try this,

=if(Column(1)<=0,Count(Distinct [organisatie_naamorg]))

Thanks.

Re: count if...

anitamanders — Tue, 10 Sep 2013 12:45:58 GMT

thanks a lot Ashok, this works perfectly !!

Re: count if...

Anonymous — Tue, 10 Sep 2013 12:49:04 GMT

Great.

welcome

Regards

Ashok

Re: count if...

Tue, 10 Sep 2013 12:50:46 GMT

Hello Anita,

if you just want to display the number of customers who didn't get the target, then I wonder if the function below helps :

=count(aggr( if( Sales < Target, Name ), Name ))

You could use a text object to test the function ( after you replaced the fields names with yours ofcourse ).

Hope this helps....