topic Asset-Liability Sum behavior in QlikView https://community.qlik.com/t5/QlikView/Asset-Liability-Sum-behavior/m-p/634821#M679060 <HTML><HEAD></HEAD><BODY><P>I have an [account type] dimension having 'asset' and 'liability' values.&nbsp; Is there a way so that QlikView by default gets the net of asset minus liability when I have a Sum(Amount) expression?&nbsp; 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.</P><P></P><P>Is the only way to do this using set operators like so?</P><P>=SUM({$&lt;[account type='asset']&gt;} Amount) - SUM({$&lt;[account type]='liability'&gt;} Amount)</P></BODY></HTML> Thu, 15 May 2014 15:19:00 GMT 2014-05-15T15:19:00Z Asset-Liability Sum behavior https://community.qlik.com/t5/QlikView/Asset-Liability-Sum-behavior/m-p/634821#M679060 <HTML><HEAD></HEAD><BODY><P>I have an [account type] dimension having 'asset' and 'liability' values.&nbsp; Is there a way so that QlikView by default gets the net of asset minus liability when I have a Sum(Amount) expression?&nbsp; 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.</P><P></P><P>Is the only way to do this using set operators like so?</P><P>=SUM({$&lt;[account type='asset']&gt;} Amount) - SUM({$&lt;[account type]='liability'&gt;} Amount)</P></BODY></HTML> Thu, 15 May 2014 15:19:00 GMT https://community.qlik.com/t5/QlikView/Asset-Liability-Sum-behavior/m-p/634821#M679060 2014-05-15T15:19:00Z