# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for
Search instead 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,

Add another expressions,

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!

Community Browser