Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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,