https://community.qlik.com/t5/QlikView/Sum-in-a-chart/m-p/352743#M1172113 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>If the fixed values are columns that really do only have a single value in the database for the dataset you are using then this will do it:</P><P></P><P>SUM(FH) + Only(FH_at_delivery) + Only(FH_before_2009)</P><P></P><P>Good luck,</P></BODY></HTML> Tue, 26 Jun 2012 18:26:54 GMT 2012-06-26T18:26:54Z https://community.qlik.com/t5/QlikView/Sum-in-a-chart/m-p/352742#M1172112 <HTML><HEAD></HEAD><BODY><P>Hello everybody, </P><P></P><P>I have a question about sum in Qlikview</P><P></P><P>I want to display a line chart, with some values varying over time and some values fixed. But the value fixed don't have to add to the line each time, </P><P>so do you know the formula please?</P><P>because my formula is: Sum({$}FH) + FH_at_delivery + FH_before_2009&nbsp; with FH_at_delivery and FH_before_2009 the fixed values.</P><P></P><P>Thank you for your help.</P></BODY></HTML> Thu, 14 Jun 2012 09:51:32 GMT https://community.qlik.com/t5/QlikView/Sum-in-a-chart/m-p/352742#M1172112 2012-06-14T09:51:32Z https://community.qlik.com/t5/QlikView/Sum-in-a-chart/m-p/352743#M1172113 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>If the fixed values are columns that really do only have a single value in the database for the dataset you are using then this will do it:</P><P></P><P>SUM(FH) + Only(FH_at_delivery) + Only(FH_before_2009)</P><P></P><P>Good luck,</P></BODY></HTML> Tue, 26 Jun 2012 18:26:54 GMT https://community.qlik.com/t5/QlikView/Sum-in-a-chart/m-p/352743#M1172113 2012-06-26T18:26:54Z