Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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)

Community Browser