https://community.qlik.com/t5/QlikView/EXPRESSION/m-p/1675719#M449758 <P>I have&nbsp; Pivot table in my qvw file where I don't get the expected output. My current output and expected output&nbsp; &nbsp;is shown below</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot_1.png" style="width: 767px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/28427iE1A6301CA6ACAFBB/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot_1.png" alt="Screenshot_1.png" /></span></P><P>The rows where changes are needed shown in red color. In fact What I need is when there are values in&nbsp; both column it should be nett off and balance shown in one column. Kindly help me correct my expression to obtain desired results.</P><P>&nbsp;</P> Fri, 14 Feb 2020 10:20:24 GMT upaliwije 2020-02-14T10:20:24Z https://community.qlik.com/t5/QlikView/EXPRESSION/m-p/1675719#M449758 <P>I have&nbsp; Pivot table in my qvw file where I don't get the expected output. My current output and expected output&nbsp; &nbsp;is shown below</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot_1.png" style="width: 767px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/28427iE1A6301CA6ACAFBB/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot_1.png" alt="Screenshot_1.png" /></span></P><P>The rows where changes are needed shown in red color. In fact What I need is when there are values in&nbsp; both column it should be nett off and balance shown in one column. Kindly help me correct my expression to obtain desired results.</P><P>&nbsp;</P> Fri, 14 Feb 2020 10:20:24 GMT https://community.qlik.com/t5/QlikView/EXPRESSION/m-p/1675719#M449758 upaliwije 2020-02-14T10:20:24Z https://community.qlik.com/t5/QlikView/EXPRESSION/m-p/1675736#M449761 <P>Please find attached a solution. I have used straight table instead of pivot because of two reasons: 1. You are not reporting a hierarchical data but a flat one and that can be simply reported using straight table. 2. You can use simpler expressions without aggr() to improve app performance.</P><P>&nbsp;</P> Fri, 14 Feb 2020 11:09:52 GMT https://community.qlik.com/t5/QlikView/EXPRESSION/m-p/1675736#M449761 tresB 2020-02-14T11:09:52Z https://community.qlik.com/t5/QlikView/EXPRESSION/m-p/1675762#M449763 <P>Thanks Tesesco,</P><P>It works but Total Value&nbsp; row is not shown in the Straight Table</P> Fri, 14 Feb 2020 12:18:35 GMT https://community.qlik.com/t5/QlikView/EXPRESSION/m-p/1675762#M449763 upaliwije 2020-02-14T12:18:35Z