Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor

Max Accumulated Value as refrence

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

chart1.PNG

2 Replies
Highlighted

Re: Max Accumulated Value as refrence

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

Highlighted
New Contributor

Re: Max Accumulated Value as refrence

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 :-).