Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kfir1987
Contributor II
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
dplr-rn
Partner - Master III
Partner - Master III

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

Hi, 

 

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

 

 

dplr-rn
Partner - Master III
Partner - Master III

Share your expression please.
kfir1987
Contributor II
Contributor II
Author

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

dplr-rn
Partner - Master III
Partner - Master III

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

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

The chart substruct  line even if the dimension is different

 

2019-05-15 17_16_26-GrabCAD - Phase 2 - Official - My new sheet _ Sheets - Qlik Sense.png

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
Partner - Master III
Partner - Master III

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

Hi,
Can you share sample data please.
kfir1987
Contributor II
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