Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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.

View solution in original post