topic Re: The total in the chart in QlikView https://community.qlik.com/t5/QlikView/The-total-in-the-chart/m-p/775994#M275121 <HTML><HEAD></HEAD><BODY><P>Hi I studied the feedbacks in the thread, but once I convert it from histogram to area chart, it loses magic. I wonder if we have option to put only total. Maybe it is impossible. </P></BODY></HTML> Tue, 24 Mar 2015 09:15:16 GMT atsushi_saijo 2015-03-24T09:15:16Z The total in the chart https://community.qlik.com/t5/QlikView/The-total-in-the-chart/m-p/775992#M275119 <HTML><HEAD></HEAD><BODY><P>I have 2 same time-series, which is displayed differently. </P><P>First chart plot individual values in 3 timeseries. </P><P>Now, how could I plot the total of value in the second graph? </P><P><IMG alt="Error 2.jpg" class="image-1 jive-image" src="/legacyfs/online/81650_Error 2.jpg" style="height: auto;" /></P><P>I would appreciate for your feedback in advance. </P></BODY></HTML> Tue, 24 Mar 2015 08:01:54 GMT https://community.qlik.com/t5/QlikView/The-total-in-the-chart/m-p/775992#M275119 atsushi_saijo 2015-03-24T08:01:54Z Re: The total in the chart https://community.qlik.com/t5/QlikView/The-total-in-the-chart/m-p/775993#M275120 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check if this helps u:</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/message/637587#637587" title="http://community.qlik.com/message/637587#637587">http://community.qlik.com/message/637587#637587</A></P><P></P><P>Thanks,</P><P>AS</P></BODY></HTML> Tue, 24 Mar 2015 08:06:18 GMT https://community.qlik.com/t5/QlikView/The-total-in-the-chart/m-p/775993#M275120 amit_saini 2015-03-24T08:06:18Z Re: The total in the chart https://community.qlik.com/t5/QlikView/The-total-in-the-chart/m-p/775994#M275121 <HTML><HEAD></HEAD><BODY><P>Hi I studied the feedbacks in the thread, but once I convert it from histogram to area chart, it loses magic. I wonder if we have option to put only total. Maybe it is impossible. </P></BODY></HTML> Tue, 24 Mar 2015 09:15:16 GMT https://community.qlik.com/t5/QlikView/The-total-in-the-chart/m-p/775994#M275121 atsushi_saijo 2015-03-24T09:15:16Z Re: The total in the chart https://community.qlik.com/t5/QlikView/The-total-in-the-chart/m-p/775995#M275122 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can enable the <STRONG>values on data points</STRONG> in expression tab</P></BODY></HTML> Tue, 24 Mar 2015 10:10:43 GMT https://community.qlik.com/t5/QlikView/The-total-in-the-chart/m-p/775995#M275122 2015-03-24T10:10:43Z Re: The total in the chart https://community.qlik.com/t5/QlikView/The-total-in-the-chart/m-p/775996#M275123 <HTML><HEAD></HEAD><BODY><P>Hi, the trouble for this option is that it also shows individual values, like first diagram. We only should show total. </P><P><IMG alt="Error 4.jpg" class="image-1 jive-image" src="/legacyfs/online/81660_Error 4.jpg" style="height: auto;" /></P></BODY></HTML> Tue, 24 Mar 2015 10:15:45 GMT https://community.qlik.com/t5/QlikView/The-total-in-the-chart/m-p/775996#M275123 atsushi_saijo 2015-03-24T10:15:45Z Re: The total in the chart https://community.qlik.com/t5/QlikView/The-total-in-the-chart/m-p/775997#M275124 <HTML><HEAD></HEAD><BODY><P>you could have something like this, if its ok for you..</P><P></P><P><IMG alt="111.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/81665_111.png" style="height: 249px; width: 620px;" /></P><P></P><P>by enabling Totals on dimension limits...</P><P></P><P></P><P><IMG alt="22.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/81666_22.png" style="height: auto;" /></P></BODY></HTML> Tue, 24 Mar 2015 10:27:06 GMT https://community.qlik.com/t5/QlikView/The-total-in-the-chart/m-p/775997#M275124 israrkhan 2015-03-24T10:27:06Z Re: The total in the chart https://community.qlik.com/t5/QlikView/The-total-in-the-chart/m-p/775998#M275125 <HTML><HEAD></HEAD><BODY><P>This option was explored, but we have additional area of total, on top of individuals.</P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/81667_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>If we enable <EM>Values on Data Points, </EM>the result is below:</P><P><IMG class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/81671_pastedImage_9.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>In this timeseries, we have dimention <SPAN style="text-decoration: underline;">Year</SPAN> and <SPAN style="text-decoration: underline;">ReCategorization</SPAN> (1-3rd, 4-6th ...), and Expression is just Sum(Value).</P><P></P><P>Sample data is:</P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/81669_pastedImage_7.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Tue, 24 Mar 2015 10:42:18 GMT https://community.qlik.com/t5/QlikView/The-total-in-the-chart/m-p/775998#M275125 atsushi_saijo 2015-03-24T10:42:18Z Re: The total in the chart https://community.qlik.com/t5/QlikView/The-total-in-the-chart/m-p/775999#M275126 <HTML><HEAD></HEAD><BODY><P>Probably this is impossible to do. Discussed with client, and approved by adding pivot chart beneath. </P></BODY></HTML> Wed, 25 Mar 2015 07:32:26 GMT https://community.qlik.com/t5/QlikView/The-total-in-the-chart/m-p/775999#M275126 atsushi_saijo 2015-03-25T07:32:26Z