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)