Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
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
(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