topic Re: Partial sum incorrect in QlikView https://community.qlik.com/t5/QlikView/Partial-sum-incorrect/m-p/1364633#M825341 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I think is because the "DISTINCT" clause.</P><P></P><P>Inside any row of your table you are counting this distinct but in the total row there are case_no that are in more than a row and is counted only once.</P><P></P><P>Regards</P></BODY></HTML> Tue, 11 Jul 2017 15:51:54 GMT jmvilaplanap 2017-07-11T15:51:54Z Partial sum incorrect https://community.qlik.com/t5/QlikView/Partial-sum-incorrect/m-p/1364631#M825339 <HTML><HEAD></HEAD><BODY><P>As you can see from my attachment, my partial sum total is incorrect by about 200 on a pivot</P><P>Anyone any ideas why this happens.</P><P></P><P>My dimensions are</P><P>Country</P><P>2 Cyclic groups</P><P>Calendar cyclic group consisting of Year, YearMonth, YearWeek</P><P></P><P>Expression</P><P>count (distinct (case_no)</P><P></P><P>Any help appreciated</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Partial-sum-incorrect/m-p/1364631#M825339 bobbydave 2020-11-25T16:16:04Z Re: Partial sum incorrect https://community.qlik.com/t5/QlikView/Partial-sum-incorrect/m-p/1364632#M825340 <HTML><HEAD></HEAD><BODY><P>Use Sum(Aggr())... like this</P><P></P><P><STRONG>Sum(Aggr(C</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>ount(DISTINCT case_no), Country, [$(=GetCurrentField(Group1)]</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>, [$(=GetCurrentField(Group2)]</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>, [$(=GetCurrentField(Group3)]))</STRONG></SPAN></SPAN></SPAN></P></BODY></HTML> Tue, 11 Jul 2017 13:41:41 GMT https://community.qlik.com/t5/QlikView/Partial-sum-incorrect/m-p/1364632#M825340 sunny_talwar 2017-07-11T13:41:41Z Re: Partial sum incorrect https://community.qlik.com/t5/QlikView/Partial-sum-incorrect/m-p/1364633#M825341 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I think is because the "DISTINCT" clause.</P><P></P><P>Inside any row of your table you are counting this distinct but in the total row there are case_no that are in more than a row and is counted only once.</P><P></P><P>Regards</P></BODY></HTML> Tue, 11 Jul 2017 15:51:54 GMT https://community.qlik.com/t5/QlikView/Partial-sum-incorrect/m-p/1364633#M825341 jmvilaplanap 2017-07-11T15:51:54Z