topic Re: Incorrect Partial Sum in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1628160#M733114 <P>Chun Fung, did Florentina's post give you what you needed?&nbsp; If so, please be sure to give them credit by using the Accept as Solution button to mark the post as the solution.&nbsp; If you did something else, consider posting that and marking it.&nbsp;&nbsp;</P> <P>I have one Help link that may shed some further light upon things for you, so you understand what is likely going on behind the scenes on this one:</P> <P><A href="https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/sum-of-rows-pivot-tables.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/sum-of-rows-pivot-tables.htm</A></P> <P>Hopefully this may be helpful.</P> <P>Regards,<BR />Brett</P> Wed, 25 Sep 2019 14:04:28 GMT Brett_Bleess 2019-09-25T14:04:28Z Incorrect Partial Sum in Pivot Table https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1623536#M733104 <P><SPAN>We design to create a pivot table with total at the bottom, however, the total is incorrect. Is there any suggestion on the expression with correct data displayed?</SPAN></P><P>&nbsp;</P><P>Actual Result:</P><P><IMG src="https://community.qlik.com/t5/image/serverpage/image-id/19134iCD300673EB51776F/image-size/medium?v=1.0&amp;px=-1" border="0" title="sample01.JPG" alt="sample01.JPG" /></P><P>&nbsp;</P><P>Expected Result:</P><P><IMG src="https://community.qlik.com/t5/image/serverpage/image-id/19135i9D2E48310AD43C6E/image-size/medium?v=1.0&amp;px=-1" border="0" title="sample02.JPG" alt="sample02.JPG" /></P><P>  </P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1623536#M733104 fungcheung 2020-11-25T16:16:04Z Re: Incorrect Partial Sum in Pivot Table https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1623545#M733105 <P>do you have duplication in actual data for combination of cost center and value? it will not show in rows but in total everything adds up</P> Fri, 13 Sep 2019 07:14:14 GMT https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1623545#M733105 asinha1991 2019-09-13T07:14:14Z Re: Incorrect Partial Sum in Pivot Table https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1623558#M733106 <P>Would you suggest any expression that we can only adds up the data showing in the rows instead of everything, thanks.&nbsp;</P> Fri, 13 Sep 2019 07:22:06 GMT https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1623558#M733106 fungcheung 2019-09-13T07:22:06Z Re: Incorrect Partial Sum in Pivot Table https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1623566#M733107 <P>can you share your expression?</P> Fri, 13 Sep 2019 07:28:31 GMT https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1623566#M733107 asinha1991 2019-09-13T07:28:31Z Re: Incorrect Partial Sum in Pivot Table https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1623570#M733108 <P>I have already attached the sample qvw file, please check it. Thanks.</P> Fri, 13 Sep 2019 07:29:48 GMT https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1623570#M733108 fungcheung 2019-09-13T07:29:48Z Re: Incorrect Partial Sum in Pivot Table https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1623572#M733109 <P>Hi,</P><P>add&nbsp;Personalnformation.Birthday inside aggr</P> Fri, 13 Sep 2019 07:30:28 GMT https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1623572#M733109 StarinieriG 2019-09-13T07:30:28Z Re: Incorrect Partial Sum in Pivot Table https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1623574#M733110 <P>Dear StarinieriG,</P><P>Sorry, I try to add PeronsalInformation.Birthday inside aggr but it still not work.</P><P>&nbsp;</P> Fri, 13 Sep 2019 07:35:12 GMT https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1623574#M733110 fungcheung 2019-09-13T07:35:12Z Re: Incorrect Partial Sum in Pivot Table https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1623576#M733111 <P>please find the file.qvw with the solution.</P><P>&nbsp;</P><P>best regards.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Cost Center</TD><TD>Sum (前線)</TD><TD>Sum (後勤)</TD><TD>Sum(Total)</TD></TR><TR><TD>1</TD><TD>0,00</TD><TD>3,67</TD><TD>3,67</TD></TR><TR><TD>2</TD><TD>0,00</TD><TD>9,75</TD><TD>9,75</TD></TR><TR><TD>5</TD><TD>0,00</TD><TD>3,33</TD><TD>3,33</TD></TR><TR><TD>6</TD><TD>0,00</TD><TD>3,80</TD><TD>3,80</TD></TR><TR><TD>7</TD><TD>0,00</TD><TD>6,67</TD><TD>6,67</TD></TR><TR><TD>9</TD><TD>0,00</TD><TD>4,94</TD><TD>4,94</TD></TR><TR><TD>10</TD><TD>0,00</TD><TD>9,00</TD><TD>9,00</TD></TR><TR><TD>11</TD><TD>0,00</TD><TD>9,50</TD><TD>9,50</TD></TR><TR><TD>12</TD><TD>0,00</TD><TD>5,50</TD><TD>5,50</TD></TR><TR><TD>14</TD><TD>0,00</TD><TD>6,09</TD><TD>6,09</TD></TR><TR><TD>15</TD><TD>0,00</TD><TD>5,50</TD><TD>5,50</TD></TR><TR><TD>18</TD><TD>0,00</TD><TD>7,88</TD><TD>7,88</TD></TR><TR><TD>23</TD><TD>0,00</TD><TD>9,00</TD><TD>9,00</TD></TR><TR><TD>25</TD><TD>0,00</TD><TD>2,50</TD><TD>2,50</TD></TR><TR><TD>28</TD><TD>0,00</TD><TD>12,00</TD><TD>12,00</TD></TR><TR><TD>29</TD><TD>0,00</TD><TD>2,00</TD><TD>2,00</TD></TR><TR><TD>44</TD><TD>0,00</TD><TD>5,00</TD><TD>5,00</TD></TR><TR><TD>60</TD><TD>0,00</TD><TD>4,00</TD><TD>4,00</TD></TR><TR><TD>107</TD><TD>5,00</TD><TD>0,00</TD><TD>5,00</TD></TR><TR><TD>108</TD><TD>6,00</TD><TD>0,00</TD><TD>6,00</TD></TR><TR><TD>109</TD><TD>12,00</TD><TD>0,00</TD><TD>12,00</TD></TR><TR><TD>111</TD><TD>5,67</TD><TD>0,00</TD><TD>5,67</TD></TR><TR><TD>113</TD><TD>7,00</TD><TD>0,00</TD><TD>7,00</TD></TR><TR><TD>114</TD><TD>7,33</TD><TD>0,00</TD><TD>7,33</TD></TR><TR><TD>116</TD><TD>5,00</TD><TD>0,00</TD><TD>5,00</TD></TR><TR><TD>117</TD><TD>13,00</TD><TD>0,00</TD><TD>13,00</TD></TR><TR><TD>125</TD><TD>3,75</TD><TD>0,00</TD><TD>3,75</TD></TR><TR><TD>130</TD><TD>8,00</TD><TD>0,00</TD><TD>8,00</TD></TR><TR><TD>134</TD><TD>3,00</TD><TD>0,00</TD><TD>3,00</TD></TR><TR><TD>136</TD><TD>8,20</TD><TD>0,00</TD><TD>8,20</TD></TR><TR><TD>138</TD><TD>1,50</TD><TD>0,00</TD><TD>1,50</TD></TR><TR><TD>141</TD><TD>12,00</TD><TD>0,00</TD><TD>12,00</TD></TR><TR><TD>143</TD><TD>8,50</TD><TD>0,00</TD><TD>8,50</TD></TR><TR><TD>145</TD><TD>7,43</TD><TD>0,00</TD><TD>7,43</TD></TR><TR><TD>146</TD><TD>6,00</TD><TD>0,00</TD><TD>6,00</TD></TR><TR><TD>160</TD><TD>6,50</TD><TD>0,00</TD><TD>6,50</TD></TR><TR><TD>161</TD><TD>7,20</TD><TD>0,00</TD><TD>7,20</TD></TR><TR><TD>162</TD><TD>8,00</TD><TD>0,00</TD><TD>8,00</TD></TR><TR><TD>170</TD><TD>7,50</TD><TD>0,00</TD><TD>7,50</TD></TR><TR><TD>172</TD><TD>9,00</TD><TD>0,00</TD><TD>9,00</TD></TR><TR><TD>173</TD><TD>1,00</TD><TD>0,00</TD><TD>1,00</TD></TR><TR><TD>174</TD><TD>5,00</TD><TD>0,00</TD><TD>5,00</TD></TR><TR><TD>175</TD><TD>12,00</TD><TD>0,00</TD><TD>12,00</TD></TR><TR><TD>181</TD><TD>11,00</TD><TD>0,00</TD><TD>11,00</TD></TR><TR><TD>182</TD><TD>3,00</TD><TD>0,00</TD><TD>3,00</TD></TR><TR><TD>184</TD><TD>5,50</TD><TD>0,00</TD><TD>5,50</TD></TR><TR><TD>187</TD><TD>9,00</TD><TD>0,00</TD><TD>9,00</TD></TR><TR><TD>189</TD><TD>6,75</TD><TD>0,00</TD><TD>6,75</TD></TR><TR><TD>190</TD><TD>4,00</TD><TD>0,00</TD><TD>4,00</TD></TR><TR><TD>192</TD><TD>6,67</TD><TD>0,00</TD><TD>6,67</TD></TR><TR><TD>210</TD><TD>4,29</TD><TD>0,00</TD><TD>4,29</TD></TR><TR><TD>211</TD><TD>16,00</TD><TD>0,00</TD><TD>16,00</TD></TR><TR><TD>215</TD><TD>9,00</TD><TD>0,00</TD><TD>9,00</TD></TR><TR><TD>222</TD><TD>10,00</TD><TD>0,00</TD><TD>10,00</TD></TR><TR><TD>225</TD><TD>9,00</TD><TD>0,00</TD><TD>9,00</TD></TR><TR><TD>230</TD><TD>3,00</TD><TD>0,00</TD><TD>3,00</TD></TR><TR><TD>231</TD><TD>13,00</TD><TD>0,00</TD><TD>13,00</TD></TR><TR><TD>232</TD><TD>4,00</TD><TD>0,00</TD><TD>4,00</TD></TR><TR><TD>233</TD><TD>5,00</TD><TD>0,00</TD><TD>5,00</TD></TR><TR><TD>234</TD><TD>8,00</TD><TD>0,00</TD><TD>8,00</TD></TR><TR><TD>240</TD><TD>14,00</TD><TD>0,00</TD><TD>14,00</TD></TR><TR><TD>241</TD><TD>6,00</TD><TD>0,00</TD><TD>6,00</TD></TR><TR><TD>243</TD><TD>6,00</TD><TD>0,00</TD><TD>6,00</TD></TR><TR><TD>245</TD><TD>7,00</TD><TD>0,00</TD><TD>7,00</TD></TR><TR><TD>246</TD><TD>6,00</TD><TD>0,00</TD><TD>6,00</TD></TR><TR><TD>401</TD><TD>0,00</TD><TD>4,00</TD><TD>4,00</TD></TR><TR><TD>461</TD><TD>0,00</TD><TD>11,00</TD><TD>11,00</TD></TR><TR><TD>Totale</TD><TD>341,78</TD><TD>125,13</TD><TD>466,91</TD></TR></TBODY></TABLE> Fri, 13 Sep 2019 07:36:53 GMT https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1623576#M733111 maxronny 2019-09-13T07:36:53Z Re: Incorrect Partial Sum in Pivot Table https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1626141#M733112 <P>hi,</P><P>the excel should be the expected output of qlikview, it is not a datasource for the case. Thanks.</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 20 Sep 2019 08:03:42 GMT https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1626141#M733112 fungcheung 2019-09-20T08:03:42Z Re: Incorrect Partial Sum in Pivot Table https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1626300#M733113 <P>pls see atash</P> Fri, 20 Sep 2019 12:33:30 GMT https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1626300#M733113 florentina_doga 2019-09-20T12:33:30Z Re: Incorrect Partial Sum in Pivot Table https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1628160#M733114 <P>Chun Fung, did Florentina's post give you what you needed?&nbsp; If so, please be sure to give them credit by using the Accept as Solution button to mark the post as the solution.&nbsp; If you did something else, consider posting that and marking it.&nbsp;&nbsp;</P> <P>I have one Help link that may shed some further light upon things for you, so you understand what is likely going on behind the scenes on this one:</P> <P><A href="https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/sum-of-rows-pivot-tables.htm" target="_blank">https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/sum-of-rows-pivot-tables.htm</A></P> <P>Hopefully this may be helpful.</P> <P>Regards,<BR />Brett</P> Wed, 25 Sep 2019 14:04:28 GMT https://community.qlik.com/t5/QlikView/Incorrect-Partial-Sum-in-Pivot-Table/m-p/1628160#M733114 Brett_Bleess 2019-09-25T14:04:28Z