topic how to show totals in a line chart with several dimensions in QlikView https://community.qlik.com/t5/QlikView/how-to-show-totals-in-a-line-chart-with-several-dimensions/m-p/240717#M91205 <HTML><HEAD></HEAD><BODY><P>Is service period the first dimension? If so, can you just check partial sums for the service period?</P><P>-Rob</P></BODY></HTML> Mon, 18 Oct 2010 21:31:59 GMT rwunderlich 2010-10-18T21:31:59Z how to show totals in a line chart with several dimensions https://community.qlik.com/t5/QlikView/how-to-show-totals-in-a-line-chart-with-several-dimensions/m-p/240714#M91202 <HTML><HEAD></HEAD><BODY><P>I have a number for service level for each period on the x-axis, for different grouped dimensions (e.g. business line, article type., business unit....).</P><P>In the same graph I also want to show the overall service level number for that period, but it doesn´t seem to work. Any suggestions?</P><P></P><P>thanks in advance</P></BODY></HTML> Mon, 18 Oct 2010 20:02:13 GMT https://community.qlik.com/t5/QlikView/how-to-show-totals-in-a-line-chart-with-several-dimensions/m-p/240714#M91202 2010-10-18T20:02:13Z how to show totals in a line chart with several dimensions https://community.qlik.com/t5/QlikView/how-to-show-totals-in-a-line-chart-with-several-dimensions/m-p/240715#M91203 <HTML><HEAD></HEAD><BODY><P>How is the overall service level calculated? I think we need some more info on your dataset and expressions. If the overall service level is a sum, then something like this may work:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Sum(TOTAL &lt;Period&gt; ServiceLevel)</PRE></BLOCKQUOTE>That is probably overly simplified, but is the basic idea. <BR /><BR /></BODY></HTML> Mon, 18 Oct 2010 20:09:44 GMT https://community.qlik.com/t5/QlikView/how-to-show-totals-in-a-line-chart-with-several-dimensions/m-p/240715#M91203 2010-10-18T20:09:44Z how to show totals in a line chart with several dimensions https://community.qlik.com/t5/QlikView/how-to-show-totals-in-a-line-chart-with-several-dimensions/m-p/240716#M91204 <HTML><HEAD></HEAD><BODY><P>The overall service level is not a sum but is simply the total count of orders on time divided by the total count of orders, it is the expression total ( across dimensions like article type etc) in the pivot table</P></BODY></HTML> Mon, 18 Oct 2010 20:48:22 GMT https://community.qlik.com/t5/QlikView/how-to-show-totals-in-a-line-chart-with-several-dimensions/m-p/240716#M91204 2010-10-18T20:48:22Z how to show totals in a line chart with several dimensions https://community.qlik.com/t5/QlikView/how-to-show-totals-in-a-line-chart-with-several-dimensions/m-p/240717#M91205 <HTML><HEAD></HEAD><BODY><P>Is service period the first dimension? If so, can you just check partial sums for the service period?</P><P>-Rob</P></BODY></HTML> Mon, 18 Oct 2010 21:31:59 GMT https://community.qlik.com/t5/QlikView/how-to-show-totals-in-a-line-chart-with-several-dimensions/m-p/240717#M91205 rwunderlich 2010-10-18T21:31:59Z how to show totals in a line chart with several dimensions https://community.qlik.com/t5/QlikView/how-to-show-totals-in-a-line-chart-with-several-dimensions/m-p/240718#M91206 <HTML><HEAD></HEAD><BODY><P>See the excel attached: the pivot table is a qlikview-excel-dump, the chart is the one it should be, i.e. with a line for the different departments plus a line for the total service level for that week</P></BODY></HTML> Tue, 19 Oct 2010 09:56:19 GMT https://community.qlik.com/t5/QlikView/how-to-show-totals-in-a-line-chart-with-several-dimensions/m-p/240718#M91206 2010-10-19T09:56:19Z