Discussion Board for collaboration on QlikView Scripting.
I have a bar chart with a Dimension of Years, and an Expression of Sum(cost)
I want to have a value on a line, over the bars, that shows how the bar values (Sum of costs for each year) increases each year.
So say, for 2009 I have $100 for 2010 I have $400 and for 2011 I have $600.
I feel like there should be a simple answer, but I cant seem to think of a simple formula to achieve the desired output as an expression.
Any help would be greatly appreciated. Thanks!
Go to Solution.
It could be possibly just need to the Sum the value in the above function?
Add another expressions,
I tried the formula and it doesn't show an error, but the chart doesn't show the values for that formula for some reason?
Have you made selections in the Year field or even without the selection the result is not the one desired?
Yes, that worked. It needed the value to be summed in order to calculate the above().