# Qlik Sense App Development

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

Announcements
New 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

## Re: Growth Rate WoW in chart

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
New Contributor II

## Re: Growth Rate WoW in chart

Hi,

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

Partner

## Re: Growth Rate WoW in chart

New Contributor II

## Re: Growth Rate WoW in chart

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

Partner

## Re: Growth Rate WoW in chart

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

## Re: Growth Rate WoW in chart

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

## Re: Growth Rate WoW in chart

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

## Re: Growth Rate WoW in chart

Hi,
Can you share sample data please.
New Contributor II

## Re: Growth Rate WoW in chart

(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