0 Replies Latest reply: May 15, 2014 11:19 AM by Roy Alcalde RSS

    Asset-Liability Sum behavior

    Roy Alcalde

      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)