topic Re: Excluding Sum in QlikView

Excluding Sum

asknyldz — Thu, 22 Oct 2015 07:51:25 GMT

Hi everyone,

My Data is;

and My formula is;

sum({<TYPE={'ACTUAL'}>}AMOUNT)

Result = 500

My question is;

I want to sum Actual with Excluding "GHI" client. How can i reformula this.

Result Should be = 250 (ABC+JKL)

Thank you

vincent_ardiet — Thu, 22 Oct 2015 12:34:08 GMT

Hi,

sum({<TYPE={'ACTUAL'}>-<CLIENT={'GHI'}>}AMOUNT)

sunny_talwar — Thu, 22 Oct 2015 12:39:50 GMT

Or this:

=Sum({<Type = {'ACTUAL'}, Client = e({<Client = {'GHI'}>})>} Amount)

asknyldz — Thu, 22 Oct 2015 13:04:06 GMT

Thanks for solutions, that's great.

But i have challenge. I want to sum Actual with Excluding more than 1 client. GHI and JKL

What is the formula?

sunny_talwar — Thu, 22 Oct 2015 15:32:57 GMT

May be this:

=Sum({<Type = {'ACTUAL'}, Client = e({<Client = {'GHI', 'JKL'}>})>} Amount)

=Sum({<Type = {'ACTUAL'}>-<Client={'GHI', 'JKL'}>}Amount)