topic Growth % calculation in QlikView

Growth % calculation

raghavsurya — Wed, 18 Jul 2012 08:26:48 GMT

Hi All,

We have a situation wherein weekly performance data is generated for multiple project teams. The requirement is to calculate the % of improvement based on the weekly data in the graph. we have below mentioned

Team	Date	Data
A Team	02-07-2012	5
B Team	02-07-2012	6
C Team	02-07-2012	3
A Team	09-07-2012	7
B Team	09-07-2012	9
C Team	09-07-2012	4
A Team	16-07-2012	4
B Team	16-07-2012	5
C Team	16-07-2012	9

For each week, we have to calculate the improvement % based on the data of previous week. We are able to achieve the same using Pivot table, but need help in achieving the same in Bar graph.

Re: Growth % calculation

Wed, 18 Jul 2012 08:36:03 GMT

try this:

=SUM({$<Team={"A Team"}>}Data)/above(SUM({$<Team={"A Team"}>}Data),1)-1

PS Your's pivot expression is wrong. You should use above instead before;)

Re: Growth % calculation

raghavsurya — Wed, 18 Jul 2012 09:19:02 GMT

thanks for the suggestion

Re: Growth % calculation

raghavsurya — Wed, 18 Jul 2012 09:31:14 GMT

Hi,

we also have additional table and bar graphs where we have to provide improvements in comparison with the first week of the month and first week of the year. For example

if the data is like this below

Team	02-07-2012	09-07-2012	16-07-2012
A Team	5	7	4
B Team	6	9	5
C Team	3	4	9

we need to calculate the improvements with 02-07-2012 weeks data as baseline. We need the result as

Team	09-07-2012	16-07-2012
A Team	40%	-29%
B Team	50%	-33%
C Team	33%	-25%

can you please let me know how to achieve this.

Regards,

Raghav