Break line in Combo Chart

[#1]

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?

Thanks in advance!

Lars Madsen

[johnw]

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.

[#3]

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

[johnw · Accepted solution]

Still not following. Is this what you mean?

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

[#5]

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

Lars Madsen

P.S. For some reason the enclosed example does only work in QV9. In E.g. 8.5.6231.5 the accumulation is not working properly!