https://community.qlik.com/t5/App-Development/Trying-to-remove-unwanted-line-in-Pivot-Table-and-Divide-amount/m-p/1704193#M53985 <P>Hi,</P><P>I have a value that is not linking with one of my dimensions creating a separate line when expanding my pivot table. I'm trying to get that line to be removed when expanding the pivot table and the amount "Undistributed Balance" to divide under the "Account" Dimension by the "Account Percentage". Let me know if this is something that can be done.</P><P>Thank you</P><P>Matt Davis</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="QLik Sense App Problem.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/34101i157F8761AE4D9739/image-size/large?v=v2&amp;px=999" role="button" title="QLik Sense App Problem.jpg" alt="QLik Sense App Problem.jpg" /></span></P> Sat, 16 Nov 2024 02:22:00 GMT mattdavis10 2024-11-16T02:22:00Z https://community.qlik.com/t5/App-Development/Trying-to-remove-unwanted-line-in-Pivot-Table-and-Divide-amount/m-p/1704193#M53985 <P>Hi,</P><P>I have a value that is not linking with one of my dimensions creating a separate line when expanding my pivot table. I'm trying to get that line to be removed when expanding the pivot table and the amount "Undistributed Balance" to divide under the "Account" Dimension by the "Account Percentage". Let me know if this is something that can be done.</P><P>Thank you</P><P>Matt Davis</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="QLik Sense App Problem.jpg" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/34101i157F8761AE4D9739/image-size/large?v=v2&amp;px=999" role="button" title="QLik Sense App Problem.jpg" alt="QLik Sense App Problem.jpg" /></span></P> Sat, 16 Nov 2024 02:22:00 GMT https://community.qlik.com/t5/App-Development/Trying-to-remove-unwanted-line-in-Pivot-Table-and-Divide-amount/m-p/1704193#M53985 mattdavis10 2024-11-16T02:22:00Z