topic count with multiple conditions in QlikView

count with multiple conditions

Tue, 15 Jun 2010 05:39:20 GMT

I have this condition :

for a dimension brand:

Count(distinct if ( InvoicedQty>Target and YYYY=vYear ,Shop))

I want to count shops that reach the target for all branches.

Can someone help me ?

Tue, 15 Jun 2010 05:47:37 GMT

I'd suggest trying the If() outside the Count() function. Something like the following:

=If((InvoicedQty>Target) and (YYYY=vYear), Count(distinct Shop), 0)

I hope that is helpful. Best regards,

James

Tue, 15 Jun 2010 06:49:28 GMT

Hi James,

My expression is working but what I would like to have is an additional line with the number shops for which the target is reached for all brands.

I have :

I Would like to have: