Only include certain values in a calculation

tmumaw — Sat, 16 Nov 2024 01:15:03 GMT

I have this calculation and it works.

Aggr(NODISTINCT Sum({<Resi={RESI},[GL Hier 1] = {[ZMR Chart of Accounts]},[HighNode] = {'ZMR_GROSS2'}>} [In company code currency_HSL] * -1), FISYR)

However I have Node1 locked on R130000000, R183000000 and R190000000. I wanted to add this to my calculation and for some reason it does not work. Does anyone see what I might be doing wrong? Thanks.

Aggr(NODISTINCT Sum({<Resi={RESI},[GL Hier 1] = {[ZMR Chart of Accounts]},[HighNode] = {'ZMR_GROSS2'},Node1={R11000000, R130000000,R183000000,R190000000}>} [In company code currency_HSL] * -1), FISYR)

Re: Only include certain values in a calculation

tmumaw — Tue, 18 Feb 2020 20:08:44 GMT

Fixed it....My fault. I forgot to reset the alternate state.

topic Re: Only include certain values in a calculation in QlikView

Only include certain values in a calculation

Re: Only include certain values in a calculation