# App Development

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for
Did you mean:
Contributor II

## Growth Rate WoW in chart

Hi,

I try to create a new chart that presents the growth rate week over week.  For example,

Week              Number of Jobs

2019 W1 -         20

2019 W2 -         30

So the growth rate is ( (30-20)/20).

please pay attention I want it as a chart and not as table

Thanks

14 Replies
Partner
You should be able to do this through above function. check below (examples here are straight tables but same can be done on chart too)
https://community.qlik.com/t5/QlikView-Documents/Missing-Manual-Above-and-Below/ta-p/1481948
Contributor II
Author

Hi,

I tried it on the chart but the numbers are wrong.

Partner
Contributor II
Author

(count(distinct [GC Printer Job GK]) - above(count(distinct [GC Printer Job GK])))/above(count(distinct [GC Printer Job GK]))

Partner
looks ok... Is the order correct?
convert your chart to a table and check the values first
Contributor II
Author

So, I checked it and I know where is the problem.

The chart substruct  line even if the dimension is different

You can see on the bottom chart 2 lines, each one of them is a customer. for example, on 2017 Week 27 the blue customer has 2 jobs and the pink one has 3 jobs.

on the upper chart, you can see the expression that appears in the previous post. So, what actually happened here is subtract of 2 lines   (Blue - Pink).

So this is an approval that above function is not good for this case

Partner
yes. if you have multiple dimensions things get trickier.
you may need to use aggr function as well.
Contributor II
Hi,
Can you share sample data please.
Contributor II
Author

(count(distinct [GC Printer Job GK]) -
aggr(above(count(distinct [GC Printer Job GK])))/above(count(distinct [GC Printer Job GK]),Customer Name Modify))

I did something like that, I aggr the data for each customer. it doesn`t work