Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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.

1 Reply
Not applicable

Re: Sum in a chart

Hi

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,

Community Browser