topic Show only Total for Dimension in line chart in QlikView https://community.qlik.com/t5/QlikView/Show-only-Total-for-Dimension-in-line-chart/m-p/1266414#M518077 <HTML><HEAD></HEAD><BODY><P>I have a line chart showing year over year growth by month, and I would like for the values on data points to show only the total for prior years or YTD for current year.&nbsp; I have researched in several other threads that are similar, but don't quite fit my situation so the solutions aren't working for me.&nbsp; </P><P>For the chart below, I want the zeros to disappear, and the numbers on the far right should be the cumulative total for the year.&nbsp; For the current year, i would like the value to show the current YTD total.&nbsp; </P><P><IMG alt="YOY Line Chart.png" class="jive-image image-1" src="/legacyfs/online/151443_YOY Line Chart.png" style="height: 285px; width: 620px;" /></P><P>I have attached an example.&nbsp; Thanks for your help.</P></BODY></HTML> Tue, 31 Jan 2017 16:26:04 GMT 2017-01-31T16:26:04Z Show only Total for Dimension in line chart https://community.qlik.com/t5/QlikView/Show-only-Total-for-Dimension-in-line-chart/m-p/1266414#M518077 <HTML><HEAD></HEAD><BODY><P>I have a line chart showing year over year growth by month, and I would like for the values on data points to show only the total for prior years or YTD for current year.&nbsp; I have researched in several other threads that are similar, but don't quite fit my situation so the solutions aren't working for me.&nbsp; </P><P>For the chart below, I want the zeros to disappear, and the numbers on the far right should be the cumulative total for the year.&nbsp; For the current year, i would like the value to show the current YTD total.&nbsp; </P><P><IMG alt="YOY Line Chart.png" class="jive-image image-1" src="/legacyfs/online/151443_YOY Line Chart.png" style="height: 285px; width: 620px;" /></P><P>I have attached an example.&nbsp; Thanks for your help.</P></BODY></HTML> Tue, 31 Jan 2017 16:26:04 GMT https://community.qlik.com/t5/QlikView/Show-only-Total-for-Dimension-in-line-chart/m-p/1266414#M518077 2017-01-31T16:26:04Z Re: Show only Total for Dimension in line chart https://community.qlik.com/t5/QlikView/Show-only-Total-for-Dimension-in-line-chart/m-p/1266415#M518078 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/151458_Capture.PNG" style="height: 280px; width: 620px;" /></P></BODY></HTML> Tue, 31 Jan 2017 16:46:42 GMT https://community.qlik.com/t5/QlikView/Show-only-Total-for-Dimension-in-line-chart/m-p/1266415#M518078 sunny_talwar 2017-01-31T16:46:42Z Re: Show only Total for Dimension in line chart https://community.qlik.com/t5/QlikView/Show-only-Total-for-Dimension-in-line-chart/m-p/1266416#M518079 <HTML><HEAD></HEAD><BODY><P>Or this:</P><P></P><P><STRONG>=PolicyMonth = Max(TOTAL &lt;PolicyYear&gt; PolicyMonth)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/151459_Capture.PNG" style="height: 273px; width: 620px;" /></P></BODY></HTML> Tue, 31 Jan 2017 16:58:30 GMT https://community.qlik.com/t5/QlikView/Show-only-Total-for-Dimension-in-line-chart/m-p/1266416#M518079 sunny_talwar 2017-01-31T16:58:30Z Re: Show only Total for Dimension in line chart https://community.qlik.com/t5/QlikView/Show-only-Total-for-Dimension-in-line-chart/m-p/1266417#M518080 <HTML><HEAD></HEAD><BODY><P>That's it!&nbsp; I forgot about the 'Show Values' option.&nbsp; Thanks!!</P></BODY></HTML> Tue, 31 Jan 2017 17:24:03 GMT https://community.qlik.com/t5/QlikView/Show-only-Total-for-Dimension-in-line-chart/m-p/1266417#M518080 2017-01-31T17:24:03Z