topic Break line in Combo Chart in QlikView

Break line in Combo Chart

Wed, 10 Jun 2009 21:40:03 GMT

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

Break line in Combo Chart

johnw — Thu, 11 Jun 2009 03:38:22 GMT

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

Thu, 11 Jun 2009 13:13:46 GMT

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

johnw — Fri, 12 Jun 2009 01:55:33 GMT

Still not following. Is this what you mean?

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

Break line in Combo Chart

Mon, 15 Jun 2009 14:04:12 GMT

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!