topic Re: Growth Column in QlikView

Growth Column

upaliwije — Tue, 03 Apr 2018 04:28:18 GMT

I have following pivot bale in my QV doc.

CLASS	2012	2013	2014
FIRE	6,781,118	7,271,519	7,339,058
HEALTH	6,747,988	8,178,199	8,486,264
MARINE	2,311,695	2,158,937	2,313,657
MISC	7,570,117	8,883,654	8,602,588
MOTOR	38,387,055	40,223,102	43,109,010

My espression for above is sum(PREMIUM)

I want to add a cloumn show growth over the years. Then the table should look like shown below

CLASS	2012	2013	%	2014	%
FIRE	6,781,118	7,271,519	7%	7,339,058	1%
HEALTH	6,747,988	8,178,199	21%	8,486,264	4%
MARINE	2,311,695	2,158,937	-7%	2,313,657	7%
MISC	7,570,117	8,883,654	17%	8,602,588	-3%
MOTOR	38,387,055	40,223,102	5%	43,109,010	7%

Kindly help me to write the expression for the above growth calculation.

Re: Growth Column

prma7799 — Tue, 03 Apr 2018 04:47:25 GMT

Can you please share formula for growth over the years

Re: Growth Column

upaliwije — Tue, 03 Apr 2018 05:00:02 GMT

(7271519-6781118)/6781118*100

Re: Growth Column

prma7799 — Tue, 03 Apr 2018 05:20:49 GMT

PFA..

Re: Growth Column

upaliwije — Tue, 03 Apr 2018 10:03:26 GMT

Thanks

I can do do it the way you suggessted. But when there are more year I have write expression for each column. Isn't there ant other way to do it please ?

Re: Growth Column

prma7799 — Tue, 03 Apr 2018 10:55:28 GMT

You can take dimension Class with Year (2 dimension) and YTD LYTD and Grwth as expression and move dimension Year on above expression