topic Re: Regarding Partial sum in Pivot table in QlikView https://community.qlik.com/t5/QlikView/Regarding-Partial-sum-in-Pivot-table/m-p/809807#M285831 <HTML><HEAD></HEAD><BODY><P>Remove the aggr() from your expression. It's unneeded because it's the same as the chart dimensions. Your expression should just be:</P><P></P><P>sum([SALESAMOUNT])</P><P></P><P>-Rob</P></BODY></HTML> Wed, 10 Dec 2014 23:28:25 GMT rwunderlich 2014-12-10T23:28:25Z Regarding Partial sum in Pivot table https://community.qlik.com/t5/QlikView/Regarding-Partial-sum-in-Pivot-table/m-p/809804#M285828 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P>I appreciate your time.</P><P>I have a pivot table in which I need to subtotal by ContractID and ContractName. But my pivot table is not working as expected. Kindly share your ideas to get a solution.</P><P>I have attached the application for your reference.</P><P>Thanks,</P><P>Kiru</P></BODY></HTML> Wed, 10 Dec 2014 21:41:12 GMT https://community.qlik.com/t5/QlikView/Regarding-Partial-sum-in-Pivot-table/m-p/809804#M285828 2014-12-10T21:41:12Z Re: Regarding Partial sum in Pivot table https://community.qlik.com/t5/QlikView/Regarding-Partial-sum-in-Pivot-table/m-p/809805#M285829 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>Please let me if you has any solutions!</P><P></P><P>Kind regards,</P><P>Kiru</P></BODY></HTML> Wed, 10 Dec 2014 22:13:45 GMT https://community.qlik.com/t5/QlikView/Regarding-Partial-sum-in-Pivot-table/m-p/809805#M285829 2014-12-10T22:13:45Z Re: Regarding Partial sum in Pivot table https://community.qlik.com/t5/QlikView/Regarding-Partial-sum-in-Pivot-table/m-p/809806#M285830 <HTML><HEAD></HEAD><BODY><P>Hi Kiru,</P><P></P><P>Please see attached.</P><P>If this is what you are looking for, you can mark it as Correct answer.</P><P></P><P>-Hemanth.</P></BODY></HTML> Wed, 10 Dec 2014 23:10:15 GMT https://community.qlik.com/t5/QlikView/Regarding-Partial-sum-in-Pivot-table/m-p/809806#M285830 2014-12-10T23:10:15Z Re: Regarding Partial sum in Pivot table https://community.qlik.com/t5/QlikView/Regarding-Partial-sum-in-Pivot-table/m-p/809807#M285831 <HTML><HEAD></HEAD><BODY><P>Remove the aggr() from your expression. It's unneeded because it's the same as the chart dimensions. Your expression should just be:</P><P></P><P>sum([SALESAMOUNT])</P><P></P><P>-Rob</P></BODY></HTML> Wed, 10 Dec 2014 23:28:25 GMT https://community.qlik.com/t5/QlikView/Regarding-Partial-sum-in-Pivot-table/m-p/809807#M285831 rwunderlich 2014-12-10T23:28:25Z Re: Regarding Partial sum in Pivot table https://community.qlik.com/t5/QlikView/Regarding-Partial-sum-in-Pivot-table/m-p/809808#M285832 <HTML><HEAD></HEAD><BODY><P>Hello Rob,</P><P></P><P>I appreciate your time and thanks so much. I got the result and it was a sample. In my real application I got another couple of fields included as a dimension,so will it affect the sum of sales?</P><P></P><P>Say for eg:</P><P>Dimensions used:</P><P>Contract ID</P><P>Contract Name</P><P>Plan</P><P>Utilization Type</P><P>Product NDC</P><P>Payment Period</P><P># of RXs</P><P>Units</P><P></P><P>Expression : </P><P>=aggr(sum([salesmaount]),[Contract ID],[Contract Name ],[Plan],[Utilization Type],[FORMULARYID],[CalendarPaymentPeriod])</P><P></P><P>Kindly let me know</P><P></P><P>Kind regards,</P><P>Kiru</P></BODY></HTML> Wed, 10 Dec 2014 23:56:11 GMT https://community.qlik.com/t5/QlikView/Regarding-Partial-sum-in-Pivot-table/m-p/809808#M285832 2014-12-10T23:56:11Z Re: Regarding Partial sum in Pivot table https://community.qlik.com/t5/QlikView/Regarding-Partial-sum-in-Pivot-table/m-p/809809#M285833 <HTML><HEAD></HEAD><BODY><P>is this?</P><P><IMG alt="p02.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/73193_p02.png" style="height: 271px; width: 620px;" /></P></BODY></HTML> Thu, 11 Dec 2014 05:02:32 GMT https://community.qlik.com/t5/QlikView/Regarding-Partial-sum-in-Pivot-table/m-p/809809#M285833 ecolomer 2014-12-11T05:02:32Z Re: Regarding Partial sum in Pivot table https://community.qlik.com/t5/QlikView/Regarding-Partial-sum-in-Pivot-table/m-p/809810#M285834 <HTML><HEAD></HEAD><BODY><P>If your aggr() dimensions are exactly the same as the chart dimensions, there is no need to use aggr(). If you want to aggregate by dimensions different than the chart, that is when you need to use aggr() or TOTAL.</P><P></P><P>-Rob</P></BODY></HTML> Thu, 11 Dec 2014 17:10:09 GMT https://community.qlik.com/t5/QlikView/Regarding-Partial-sum-in-Pivot-table/m-p/809810#M285834 rwunderlich 2014-12-11T17:10:09Z Re: Regarding Partial sum in Pivot table https://community.qlik.com/t5/QlikView/Regarding-Partial-sum-in-Pivot-table/m-p/809811#M285835 <HTML><HEAD></HEAD><BODY><P>Hello Hemanth,</P><P></P><P>Thank you, but still I am getting some issue, could you kindly have a look at it and let me know because I have another couple of fields associated with it.</P><P>I have attached the application for your reference.</P><P></P><P>Kind regards,</P><P>Kiru</P></BODY></HTML> Thu, 11 Dec 2014 18:23:26 GMT https://community.qlik.com/t5/QlikView/Regarding-Partial-sum-in-Pivot-table/m-p/809811#M285835 2014-12-11T18:23:26Z