# Qlik Sense App Development

Not applicable

## how do i get the increase/decrease by year?

Hello guys,

I have the next question:

I have a dimension year and the measurment sales. Now i want a table or graph or bargraph with the increase or decrease by year. Like this:

 year sales increase/decrease sales compared to last year 2010 100 2011 200 100% 2012 150 -25% 2013 450 200% 2014 600 33% 2015 900 50%

How can i make this column and tihs table?

I hope somebody can help. thanks!

regards,

camiel

Tags (1)
1 Solution

Accepted Solutions
MVP

## Re: how do i get the increase/decrease by year?

Dimension year

Then two expressions

=Sum(sales)

=Sum(sales)/above(Sum(sales))-1

4 Replies
MVP

## Re: how do i get the increase/decrease by year?

Dimension year

Then two expressions

=Sum(sales)

=Sum(sales)/above(Sum(sales))-1

Not applicable

## Re: how do i get the increase/decrease by year?

Hello swuehl,

Thank you!

Sometimes it's so simpel. But do you don't see what the solution is. i didn't knew about above.

Not applicable

## Re: how do i get the increase/decrease by year?

Hi Swuehl , I have same problem but small change in the dimension , I have Dimension Year-Quarter like 2015-Q1, 2015-Q2 ...

for this I would like to show the variance for 5 years in the bar chart, and I want to apply year, quarter filters also could you please guide me on this

MVP

## Re: how do i get the increase/decrease by year?

By accident Henric just wrote about Above() today:

The Above Function