Growth Rate WoW in chart

[kfir1987]

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

[dplr-rn]

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

[kfir1987]

Hi, 

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

[dplr-rn]

Share your expression please.

[kfir1987]

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

[dplr-rn]

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

[kfir1987]

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

[dplr-rn]

yes. if you have multiple dimensions things get trickier.
you may need to use aggr function as well.

[Saranyat]

Hi,
Can you share sample data please.

[kfir1987]

(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