topic Growth Percentages in QlikView

Growth Percentages

tmumaw — Tue, 07 Jul 2009 22:45:50 GMT

Hello all: I have a pivot table with years across top and weeks down the left side. I need to calculate a % of growth for each week/year combo. How is this accheived? I have tried befores and afters with different results, but not what I am looking for. Example

years 2005 2006 2007

Weeks

01 10 20 30

I need to see the growth between 2005 and 2006, then 2006 and 2007.by week

Thanks
Thom

Growth Percentages

Wed, 08 Jul 2009 03:28:52 GMT

Marking the checkbox "Relative" option is not available for Pivot Tables.

Regards

Eraaj

Growth Percentages

bismart — Wed, 08 Jul 2009 19:02:12 GMT

Year	2005			2006			2007
Month	Qty	Variance	Var%	Qty	Variance	Var%	Qty	Variance	Var%
01	10			20	10	100%	30	10	50%
02	6			10	4	67%	8	-2	-20%

Variance Expression : (Sum(Qty) - before(Sum(Qty)))

Var% Expression: (Sum(Qty) - before(Sum(Qty)))/before(Sum(Qty))

Growth Percentages

tmumaw — Wed, 08 Jul 2009 21:37:35 GMT

Bismart,

Thank you very much. This was exactly what I was looking for. You have a great day.

Thom

Growth Percentages

tmumaw — Thu, 23 Jul 2009 21:55:09 GMT

Good Morning Bismark,

I have another question for you. I need to do the same thing for customer counts, however this statement does not work any ideas? Thanks in advance.

Thom

(

Count (DISTINCT [Ship To]) - beforeCount (DISTINCT [Ship To]) / beforeCount (DISTINCT [Ship To]

)