topic Exclude amount from Total in QlikView

Exclude amount from Total

Wed, 18 Dec 2013 15:31:04 GMT

Hi,

I'm trying to add an expression into my chart that shows the sum of Actual Amount which excludes the items that relate to a specific ledger account (324010). I've tried the following;

SUM({$<~[GL Account]={324010}>}[Actual Month])

and

SUM({$<[Actual Month]={"*"}-{324010}>}[Actual Month])

but each time my chart shows the Total of the actual amount without subtracting the amount relating to 324010 - is there a way of doing this please?

Thanks,

Caroline

Re: Exclude amount from Total

swuehl — Wed, 18 Dec 2013 15:35:18 GMT

Have you tried

SUM({$<[GL Account] -= {324010}>} [Actual Month])

Re: Exclude amount from Total

danieloberbilli — Wed, 18 Dec 2013 17:10:39 GMT

or like this for current selection excluding GL-Account 324010:

SUM({$-1<[GL Account]={324010}>}[Actual Month])

Re: Exclude amount from Total

preminqlik — Wed, 18 Dec 2013 17:51:39 GMT

please check the expression that you have written

correct expression is SUM({$<[GL Account]={"*"}-{324010}>}[Actual Month])