Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
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