Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
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
dilipranjith
Partner
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
kfir1987
Contributor II
Contributor II
Author

Hi, 

 

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

 

 

dilipranjith
Partner
Partner

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]))

dilipranjith
Partner
Partner

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

dilipranjith
Partner
Partner

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