Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Asset-Liability Sum behavior

I have an [account type] dimension having 'asset' and 'liability' values.  Is there a way so that QlikView by default gets the net of asset minus liability when I have a Sum(Amount) expression?  I'm just trying to replicate the SSAS capability where you can assign an operator to a dimension to indicate whether it will do addition(+) or subtraction(-) when doing aggregations.

Is the only way to do this using set operators like so?

=SUM({$<[account type='asset']>} Amount) - SUM({$<[account type]='liability'>} Amount)

0 Replies