Month to Month growth

[#1]

Hello community,

I have a pivot table in below format and I want to calculate the % growth based on this month vs previous month.

Any one has a clue how to achieve this in Qlikview in the required pivot table format?

Month	FinYear	2005	2006	2007	2008	2009	2010	2011	2012
Apr		0	3,587	4,054	4,669	2,013	6,357	5,799	6,568
May		0	5,278	4,817	4,610	4,515	7,014	6,759	7,670
Jun		0	3,991	3,523	4,044	4,952	7,046	8,109	6,819
Jul		0	3,739	3,331	4,204	4,332	6,280	6,875	5,994
Aug		3,067	4,347	4,352	5,439	4,274	7,409	6,900	6,561
Sep		3,322	3,645	4,545	6,699	4,823	5,798	5,921	7,329
Oct		4,007	4,643	4,646	5,888	5,535	6,394	6,616	6,800
Nov		5,432	4,779	6,623	4,547	8,073	7,147	8,223	7,553
Dec		6,812	7,891	8,312	7,136	7,536	10,364	9,539	11,916
Jan		5,545	6,156	5,203	6,708	6,614	7,283	8,457	9,171
Feb		4,029	4,949	3,905	3,740	5,646	5,548	5,298	1,559
Mar		3,562	4,597	5,645	4,973	4,875	6,230	5,524	0

Thanks & Regards,

Sandip Patel

[jvitantonio]

Hi,

Check out the functions before and above.

[#3]

Hi,

Thanks for your reply and time, appreciate it.

I have tried above function and it works fine expect the first month of the year.

i.e.

to calculate growth % for the Arpil 2006 I need to get the value of March 2005 which I can not get with the Above function.

[jvitantonio]

If you read the help, it says that the first row of the table will be null as there are no value to compare.

If the table is fixed, then I recommend you assign that March value to a variable and then use IF with the Above function

something like

If(month = 'Apr' and Year = '2006', Sum(Value)/$(variable), (Sum(Value)-Above(Sum(Value))/Above(Sum(Value));

[#5]

Thanks.

I will try this.

Is there any other way to achieve this with Set Analysis?

[jvitantonio]

I don't think so for this case...