topic Line chart 'total line' in QlikView https://community.qlik.com/t5/QlikView/Line-chart-total-line/m-p/327728#M120669 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you attach the sample.</P><P></P><P>Try this expression for Total</P><P></P><P>=Sum(TOTAL &lt;Period&gt; Sales)</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Wed, 29 Feb 2012 12:05:22 GMT jagan 2012-02-29T12:05:22Z Line chart 'total line' https://community.qlik.com/t5/QlikView/Line-chart-total-line/m-p/327727#M120668 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a line chart with sum(Sales) broken down over time (Month) and Category.&nbsp; </P><P></P><P>I want to have a total line above the category breakdown so you can easily see the contribution by category to this total as well as being able to actually see the total as an absolute value.&nbsp; This total line would be over time but not category, so it would change each month along with the category breakdown.</P><P></P><P>Has anyone managed to do this?</P><P></P><P>Thanks</P><P></P><P>GC</P></BODY></HTML> Wed, 29 Feb 2012 11:11:59 GMT https://community.qlik.com/t5/QlikView/Line-chart-total-line/m-p/327727#M120668 2012-02-29T11:11:59Z Line chart 'total line' https://community.qlik.com/t5/QlikView/Line-chart-total-line/m-p/327728#M120669 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you attach the sample.</P><P></P><P>Try this expression for Total</P><P></P><P>=Sum(TOTAL &lt;Period&gt; Sales)</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Wed, 29 Feb 2012 12:05:22 GMT https://community.qlik.com/t5/QlikView/Line-chart-total-line/m-p/327728#M120669 jagan 2012-02-29T12:05:22Z