topic Re: Growth Rate WoW in chart in App Development

Growth Rate WoW in chart

kfir1987 — Wed, 15 May 2019 12:24:20 GMT

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

Re: Growth Rate WoW in chart

dplr-rn — Wed, 15 May 2019 13:52:34 GMT

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

Re: Growth Rate WoW in chart

kfir1987 — Wed, 15 May 2019 14:00:27 GMT

Hi,

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

Re: Growth Rate WoW in chart

dplr-rn — Wed, 15 May 2019 14:08:53 GMT

Share your expression please.

Re: Growth Rate WoW in chart

kfir1987 — Wed, 15 May 2019 14:11:02 GMT

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

Re: Growth Rate WoW in chart

dplr-rn — Wed, 15 May 2019 14:12:55 GMT

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

Re: Growth Rate WoW in chart

kfir1987 — Wed, 15 May 2019 14:23:57 GMT

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

Re: Growth Rate WoW in chart

dplr-rn — Wed, 15 May 2019 14:26:34 GMT

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

Re: Growth Rate WoW in chart

Saranyat — Wed, 15 May 2019 16:30:12 GMT

Hi,
Can you share sample data please.

Re: Growth Rate WoW in chart

kfir1987 — Wed, 15 May 2019 16:43:23 GMT

(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

Re: Growth Rate WoW in chart

Saranyat — Thu, 16 May 2019 08:07:35 GMT

Can you please share some sample data.cant play without data.

Re: Growth Rate WoW in chart

kfir1987 — Thu, 16 May 2019 08:22:34 GMT

sure, please find the attached xls

Re: Growth Rate WoW in chart

Saranyat — Thu, 16 May 2019 10:12:07 GMT

Hi,

with the data you shared below expression worked for me

=((Jobs) - above(Jobs))/above(Jobs)

Re: Growth Rate WoW in chart

Saranyat — Thu, 16 May 2019 10:12:54 GMT

Re: Growth Rate WoW in chart

kfir1987 — Thu, 16 May 2019 10:35:31 GMT

If more than one customer selected is it work fine ?