topic error aggr on pivot table in QlikView https://community.qlik.com/t5/QlikView/error-aggr-on-pivot-table/m-p/153240#M30357 <HTML><HEAD></HEAD><BODY><P>SOLVED AGGR(NODISTINCT......</P></BODY></HTML> Tue, 04 Jan 2011 18:12:49 GMT 2011-01-04T18:12:49Z error aggr on pivot table https://community.qlik.com/t5/QlikView/error-aggr-on-pivot-table/m-p/153239#M30356 <HTML><HEAD></HEAD><BODY><P>&lt;body&gt;&lt;p&gt;Dear all&lt;/p&gt; &lt;p&gt;I have an error on a pivot table and i dont know how to solve it. &lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;p&gt;I have 3 Dimensions an one of them is a calculated one. &lt;/p&gt; &lt;p&gt;I have to expressions. &lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;p&gt;A sum and another one to calculate percentaje. &lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;p&gt;Problem is that aggr function only give me the correct data on one column and not in all. &lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;p&gt;Here is data obtained, but I need all the aggr be 736 on D1-1 D2-1 and not null , and 636 on D1-1 D2-2 to do Numericcount/aggr to get percentaje&lt;/p&gt; &lt;p&gt;&lt;a href="https://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/1638.Esquema.JPG"&gt;&lt;img src="/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/1638.Esquema.JPG" border="0" /&gt;&lt;/a&gt;&lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;p&gt;&lt;col width="98"&gt;&lt;/col&gt; &lt;col width="98"&gt;&lt;/col&gt; &lt;col width="98"&gt;&lt;/col&gt; &lt;col width="493"&gt;&lt;/col&gt; &lt;col width="229"&gt;&lt;/col&gt; &lt;tr height="17"&gt; &lt;td height="17" class="xl24" width="98"&gt;&lt;br /&gt;&lt;/td&gt; &lt;td class="xl24" width="98"&gt;&lt;br /&gt;&lt;/td&gt; &lt;td class="xl25" width="98"&gt;&lt;br /&gt;&lt;/td&gt; &lt;td class="xl22" width="493"&gt;&lt;/td&gt; &lt;td class="xl22" width="229"&gt;&lt;br /&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt;&lt;/body&gt;</P></BODY></HTML> Tue, 04 Jan 2011 17:41:16 GMT https://community.qlik.com/t5/QlikView/error-aggr-on-pivot-table/m-p/153239#M30356 2011-01-04T17:41:16Z error aggr on pivot table https://community.qlik.com/t5/QlikView/error-aggr-on-pivot-table/m-p/153240#M30357 <HTML><HEAD></HEAD><BODY><P>SOLVED AGGR(NODISTINCT......</P></BODY></HTML> Tue, 04 Jan 2011 18:12:49 GMT https://community.qlik.com/t5/QlikView/error-aggr-on-pivot-table/m-p/153240#M30357 2011-01-04T18:12:49Z