topic Re: Exclude data form the count in QlikView

Exclude data form the count

Thu, 14 Jun 2012 14:08:56 GMT

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

Re: Exclude data form the count

MayilVahanan — Thu, 14 Jun 2012 14:13:05 GMT

Hi,

Try this,

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

Hope it helps

Re: Exclude data form the count

Thu, 14 Jun 2012 14:30:22 GMT

Thanks It done the job

Re: Exclude data form the count

Fri, 22 Nov 2013 16:20:38 GMT

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)

Re: Exclude data form the count

Fri, 22 Nov 2013 16:34:35 GMT

try this

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

Re: Exclude data form the count

Fri, 22 Nov 2013 16:35:12 GMT

try this

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

Re: Exclude data form the count

Fri, 22 Nov 2013 16:56:06 GMT

Beautiful, thanks