1 Reply Latest reply: Jun 26, 2012 2:26 PM by Nigel West RSS

    Sum in a chart

      Hello everybody,


      I have a question about sum in Qlikview


      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,

      so do you know the formula please?

      because my formula is: Sum({$}FH) + FH_at_delivery + FH_before_2009  with FH_at_delivery and FH_before_2009 the fixed values.


      Thank you for your help.

        • Re: Sum in a chart



          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:


          SUM(FH) + Only(FH_at_delivery) + Only(FH_before_2009)


          Good luck,