Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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:

  

yearsalesincrease/decrease sales compared to last year
2010100
2011200100%
2012150-25%
2013450200%
201460033%
2015900

50%

How can i make this column and tihs table?

I hope somebody can help. thanks!

regards,

camiel

1 Solution

Accepted Solutions
MVP
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
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
MVP

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

By accident Henric just wrote about Above() today:

The Above Function