topic Re: Partial sum wrong in QlikView https://community.qlik.com/t5/QlikView/Partial-sum-wrong/m-p/1406367#M812590 <HTML><HEAD></HEAD><BODY><P>I tried this but its not working</P></BODY></HTML> Mon, 25 Sep 2017 12:08:30 GMT srishsum2017 2017-09-25T12:08:30Z Partial sum wrong https://community.qlik.com/t5/QlikView/Partial-sum-wrong/m-p/1406365#M812585 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>I am using a Pivot table with the dimension of zone, sales office, product and dealer and taking the count(Quantities), my data is coming correct but at zone level the partial sum comes wrong.</P><P>Please help me to solve this</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Partial-sum-wrong/m-p/1406365#M812585 srishsum2017 2020-11-25T16:16:04Z Re: Partial sum wrong https://community.qlik.com/t5/QlikView/Partial-sum-wrong/m-p/1406366#M812588 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this expression.</P><P></P><P>Sum(Aggr(Count(Quantities),Zone,SalesOffice,Product,Dealer))</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Mon, 25 Sep 2017 12:07:31 GMT https://community.qlik.com/t5/QlikView/Partial-sum-wrong/m-p/1406366#M812588 kaushiknsolanki 2017-09-25T12:07:31Z Re: Partial sum wrong https://community.qlik.com/t5/QlikView/Partial-sum-wrong/m-p/1406367#M812590 <HTML><HEAD></HEAD><BODY><P>I tried this but its not working</P></BODY></HTML> Mon, 25 Sep 2017 12:08:30 GMT https://community.qlik.com/t5/QlikView/Partial-sum-wrong/m-p/1406367#M812590 srishsum2017 2017-09-25T12:08:30Z Re: Partial sum wrong https://community.qlik.com/t5/QlikView/Partial-sum-wrong/m-p/1406368#M812591 <HTML><HEAD></HEAD><BODY><P>It should work. If possible share sample data.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Mon, 25 Sep 2017 12:10:48 GMT https://community.qlik.com/t5/QlikView/Partial-sum-wrong/m-p/1406368#M812591 kaushiknsolanki 2017-09-25T12:10:48Z Re: Partial sum wrong https://community.qlik.com/t5/QlikView/Partial-sum-wrong/m-p/1406369#M812592 <HTML><HEAD></HEAD><BODY><P>Share some data or do you have any blank zones there or may be use <STRONG>Sum of Rows</STRONG> in the chart properties.</P></BODY></HTML> Mon, 25 Sep 2017 12:11:30 GMT https://community.qlik.com/t5/QlikView/Partial-sum-wrong/m-p/1406369#M812592 its_anandrjs 2017-09-25T12:11:30Z Re: Partial sum wrong https://community.qlik.com/t5/QlikView/Partial-sum-wrong/m-p/1406370#M812593 <HTML><HEAD></HEAD><BODY><P>Dear,</P><P></P><P>Attach the sample Data.</P></BODY></HTML> Mon, 25 Sep 2017 12:11:50 GMT https://community.qlik.com/t5/QlikView/Partial-sum-wrong/m-p/1406370#M812593 mdmukramali 2017-09-25T12:11:50Z