topic Pivot / Subtotal Som / Dimensionality / AGGR() Question in QlikView https://community.qlik.com/t5/QlikView/Pivot-Subtotal-Som-Dimensionality-AGGR-Question/m-p/542022#M1128415 <HTML><HEAD></HEAD><BODY><P>Dear specialists,</P><P></P><P>Would you please take a look at my Qlikview Document.</P><P>I think my question is pretty clear when you see the pivot tabel but let me try to explain what I want.</P><P></P><P>My pivot table has one expression : Total (Sum(Amount))</P><P>The result can be (also depending on other selections) a positive or a negative number.</P><P>When the sum is larger then 0 I want it to show in one column, when it is negative it needs to be in the other column.</P><P></P><P>How do I get to sum them for the subtotals? </P><P></P><P></P><P>Thanks.</P></BODY></HTML> Fri, 06 Dec 2013 16:49:14 GMT Anonymous 2013-12-06T16:49:14Z Pivot / Subtotal Som / Dimensionality / AGGR() Question https://community.qlik.com/t5/QlikView/Pivot-Subtotal-Som-Dimensionality-AGGR-Question/m-p/542022#M1128415 <HTML><HEAD></HEAD><BODY><P>Dear specialists,</P><P></P><P>Would you please take a look at my Qlikview Document.</P><P>I think my question is pretty clear when you see the pivot tabel but let me try to explain what I want.</P><P></P><P>My pivot table has one expression : Total (Sum(Amount))</P><P>The result can be (also depending on other selections) a positive or a negative number.</P><P>When the sum is larger then 0 I want it to show in one column, when it is negative it needs to be in the other column.</P><P></P><P>How do I get to sum them for the subtotals? </P><P></P><P></P><P>Thanks.</P></BODY></HTML> Fri, 06 Dec 2013 16:49:14 GMT https://community.qlik.com/t5/QlikView/Pivot-Subtotal-Som-Dimensionality-AGGR-Question/m-p/542022#M1128415 Anonymous 2013-12-06T16:49:14Z Re: Pivot / Subtotal Som / Dimensionality / AGGR() Question https://community.qlik.com/t5/QlikView/Pivot-Subtotal-Som-Dimensionality-AGGR-Question/m-p/542023#M1128416 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Fri, 06 Dec 2013 17:02:39 GMT https://community.qlik.com/t5/QlikView/Pivot-Subtotal-Som-Dimensionality-AGGR-Question/m-p/542023#M1128416 Gysbert_Wassenaar 2013-12-06T17:02:39Z Re: Pivot / Subtotal Som / Dimensionality / AGGR() Question https://community.qlik.com/t5/QlikView/Pivot-Subtotal-Som-Dimensionality-AGGR-Question/m-p/542024#M1128417 <HTML><HEAD></HEAD><BODY><P>Thanks Gysbert, Seems to work great!</P></BODY></HTML> Fri, 06 Dec 2013 19:04:54 GMT https://community.qlik.com/t5/QlikView/Pivot-Subtotal-Som-Dimensionality-AGGR-Question/m-p/542024#M1128417 Anonymous 2013-12-06T19:04:54Z