Exclude data form the count

[#1]

Hi,

I am new to QlikView, I am building one of my first tables and I am stuck

I need to count total repairs and exclude "product A" total count from it.

can somebody point me to the right direction?

Thanks,

Evaldas

[MayilVahanan]

Hi,

     Try this,

     =Count({<Product -={'productA'}>}repairs)

     Hope it helps

[#3]

Thanks It done the job

[#4]

On a similar point, I need to include two different variables, so for example; total revenue only including Product A as well as Category B.Something like the below; but this doesn't work:

=Sum({<Product={'productA'}>},{<Category={'categoryB'}>}Revenue)

[#5]

try this

=Sum({<Product={'productA'} , Category={'categoryB'}>}Revenue)

[#6]

try this

=Sum({<Product={'productA'} , Category={'categoryB'}>}Revenue)

[#7]

Beautiful, thanks