5 Replies Latest reply: Feb 23, 2012 4:49 AM by Juan Vitantonio

# Month to Month growth

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

• ###### Month to Month growth

Hi,

Check out the functions before and above.

• ###### Month to Month growth

Hi,

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.

• ###### Re: Month to Month growth

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));

• ###### Month to Month growth

Thanks.

I will try this.

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

• ###### Month to Month growth

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