Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Only include certain values in a calculation

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)

Labels (1)
1 Solution

Accepted Solutions
tmumaw
Specialist II
Specialist II
Author

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

View solution in original post

1 Reply
tmumaw
Specialist II
Specialist II
Author

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