# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for
Did you mean:
Partner

## Show Increase/Decrease over yrs in chart

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.

YearsSum of CostIncrease/DecreaseLogic for Increase/Decrease Formula
2009\$100\$0None - 2009
2010\$400\$3002009 - 2010
2011\$600\$2002010 - 2011

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!

1 Solution

Accepted Solutions
Partner

HI,

It could be possibly just need to the Sum the value in the above function?

Sum(Cost)-Above(Sum(Cost))

Mark

5 Replies
Partner

Hi,

Sum(Cost)-Above(Cost)

Mark

Partner
Author

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?

MVP

Have you made selections in the Year field or even without the selection the result is not the one desired?

Partner

HI,

It could be possibly just need to the Sum the value in the above function?

Sum(Cost)-Above(Sum(Cost))

Mark

Partner
Author

Yes, that worked. It needed the value to be summed in order to calculate the above().

Thank you!