topic Re: Total and subtotal in chart in QlikView https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827674#M1002794 <HTML><HEAD></HEAD><BODY><P>Every Measure is Sum(Measure)</P></BODY></HTML> Thu, 04 Jun 2015 12:34:19 GMT clovati 2015-06-04T12:34:19Z Total and subtotal in chart https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827671#M1002789 <HTML><HEAD></HEAD><BODY><P>Hi everybody!</P><P>I have a chart with 3 dimensions and some measures in which I see Total for every dimensionand for the entire chart.</P><P>I copy it in another sheet, change the dimensions with other dimensions. I still have subtotals but the total for the entire chart disappears ... why?</P><P>Thank you in advance.</P></BODY></HTML> Thu, 04 Jun 2015 12:23:31 GMT https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827671#M1002789 clovati 2015-06-04T12:23:31Z Re: Total and subtotal in chart https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827672#M1002791 <HTML><HEAD></HEAD><BODY><P>Have you applied an aggregation function around the attributes in your expression, like</P><P>=sum(Sales)</P><P></P><P>instead of only </P><P>=Sales</P><P></P><P>?</P></BODY></HTML> Thu, 04 Jun 2015 12:25:53 GMT https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827672#M1002791 swuehl 2015-06-04T12:25:53Z Re: Total and subtotal in chart https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827673#M1002793 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Cristina - Are you referring to Straight or Pivot chart? Are they linked objects? Do you have any calculated dimensions in new chart? Please post the QVW file and one of us can answer the question.</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Cheers,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">DV</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">www.QlikShare.com</SPAN></P></BODY></HTML> Thu, 04 Jun 2015 12:27:20 GMT https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827673#M1002793 IAMDV 2015-06-04T12:27:20Z Re: Total and subtotal in chart https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827674#M1002794 <HTML><HEAD></HEAD><BODY><P>Every Measure is Sum(Measure)</P></BODY></HTML> Thu, 04 Jun 2015 12:34:19 GMT https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827674#M1002794 clovati 2015-06-04T12:34:19Z Re: Total and subtotal in chart https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827675#M1002795 <HTML><HEAD></HEAD><BODY><P>It's a PIVOT CHART, thanks</P></BODY></HTML> Thu, 04 Jun 2015 12:34:59 GMT https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827675#M1002795 clovati 2015-06-04T12:34:59Z Re: Total and subtotal in chart https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827676#M1002796 <HTML><HEAD></HEAD><BODY><P>Hi Cristina</P><P></P><P>i guess because the dimension you changed was the first one</P><P>when you change dimension you have to check again partial sums</P><P></P><P>Best regards</P><P>Chris</P></BODY></HTML> Thu, 04 Jun 2015 12:39:15 GMT https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827676#M1002796 2015-06-04T12:39:15Z Re: Total and subtotal in chart https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827677#M1002797 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Just to make sure did you enable "Show Partial Sums" and "SubTotals" at top/bottom?<IMG alt="04-06-2015 13-41-56.png" class="jive-image image-1" src="/legacyfs/online/88383_04-06-2015 13-41-56.png" style="height: 546px; width: 620px;" /></SPAN></P></BODY></HTML> Thu, 04 Jun 2015 12:41:40 GMT https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827677#M1002797 IAMDV 2015-06-04T12:41:40Z Re: Total and subtotal in chart https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827678#M1002798 <HTML><HEAD></HEAD><BODY><P>Yes, it is when I change the first dimension.</P><P>Then show partial is disabled. Having a lot of measures, any idea on how can I re-use my measueres? thx</P></BODY></HTML> Thu, 04 Jun 2015 13:45:26 GMT https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827678#M1002798 clovati 2015-06-04T13:45:26Z Re: Total and subtotal in chart https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827679#M1002799 <HTML><HEAD></HEAD><BODY><P>I Found how to do. In dimension I do EDIT, then re-write ex-novo the name of the dimension I want to be summerized. Thx to all</P></BODY></HTML> Thu, 04 Jun 2015 13:53:08 GMT https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827679#M1002799 clovati 2015-06-04T13:53:08Z Re: Total and subtotal in chart https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827680#M1002800 <HTML><HEAD></HEAD><BODY><P>when you modify dimension you remove it before creating a new one. </P><P></P><P>you use calculated dimension (edit, change field)</P><P>in this way, it is not considered a removing dimension</P><P></P><P>Chris</P></BODY></HTML> Thu, 04 Jun 2015 13:53:36 GMT https://community.qlik.com/t5/QlikView/Total-and-subtotal-in-chart/m-p/827680#M1002800 2015-06-04T13:53:36Z