# Break line in Combo Chart

Hi Qliks!

In the enclosed application I have a combo chart. Eventually I want my chart to show Actuals YTD, Plan FY and finally the variance YTD.

Problem: How do I stop the variance line from calculating after the month selected = YTD variance?

• ###### Break line in Combo Chart

Here's one way:

if(Month,[Plan FY]-[Actual YTD])

It works because Month only has a value for the selected values, and any value other than 0 is considered to be true.

• ###### Break line in Combo Chart

Hi John!

Thanks for you reply. Maybe I wasn't clear enough. Since I need the Variance YTD the calculation must include an accumulation. Using the standard setting in QV will not do the trick, since it will then accumulate FY.

I guess my question is down to: "how do I build an accumulation into my calculation"

Probably using RangeSum .....

Regards,

Lars

• ###### Break line in Combo Chart

Still not following. Is this what you mean?

if(Month,rangesum([Plan FY] - [Actual YTD],above([Variance YTD])))

• ###### Break line in Combo Chart

Thanks John!

I did not realize that I can relate to the current calculation "Variance YTD" in the "Above" function.

That does the trick! - since I would like to be able to see the Actuals and Variance YTD by only selecting year and the "last" month in the YTD period (as opposed to selecting all months YTD myself) I combined your suggestion with a Set Analysis in the enclosed example.

Thanks again