Qlik Community

Qlik Sense App Development

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

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
kfir1987
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
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
kfir1987
New Contributor II

Re: Growth Rate WoW in chart

Hi, 

 

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

 

 

Partner
Partner

Re: Growth Rate WoW in chart

Share your expression please.
kfir1987
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
Partner

Re: Growth Rate WoW in chart

looks ok... Is the order correct?
convert your chart to a table and check the values first
kfir1987
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

 

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

Partner
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.
Saranyat
New Contributor II

Re: Growth Rate WoW in chart

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