topic Re: Max Accumulated Value as refrence in QlikView

Max Accumulated Value as refrence

Anonymous — Thu, 15 Dec 2016 12:35:35 GMT

Hi,

I'm not sure how to get my chart to show what I want. So hopefully someone can help me
This is I want to do
1) The green line I want as a reference it should be max of a accumulate value. In my picture that is the dotted yellow line. Need to show if the accumulated value is under the total budget of the year.
2) The red part in the stacked chart is now added on a accumulated value. I want to show for example that in June if cost are £ 100 and the accumulated cost are 750. I do not want it as percent.

Chart explanation:
Blue - Accumulated costs
Red - Monthly cost
Green - Budget

Re: Max Accumulated Value as refrence

sunny_talwar — Thu, 15 Dec 2016 16:49:24 GMT

Not sure I completely understand your requirement. Would you be able to share a sample to look at this? and also share the expected output?

Best,

Sunny

Re: Max Accumulated Value as refrence

Anonymous — Fri, 16 Dec 2016 09:41:01 GMT

Thank's Sunny for taking up your time

I did the correct way in my first solution. I hade some errors in my data model that changed the result. All that was needed was to look it again after some pause :-).