topic Creating a % change calculation in QlikView

Creating a % change calculation

Wed, 31 Mar 2010 12:22:04 GMT

Hi,

I am looking for a solution to creating a column within a table to show the value's relationship with the previous column.

For my specific example, I have a table showing months and number of sales. What I need to create is a a column which shows the percentage change in the value from the previous month.

e.g If December 2009 sales are 100 units, and January 2010 are 110 units, how do I create an expression, within the table or on a new table, which shows that January sales are 10% higher than in December.?

I suspect this is probably not that difficult but have hit a brick wall.

Many Thanks

Jason

Creating a % change calculation

Anonymous — Wed, 31 Mar 2010 12:23:56 GMT

did you already try something like

previous(month) ??

Creating a % change calculation

Wed, 31 Mar 2010 12:31:51 GMT

Hi Jason,

see the attached example.

Good luck!

Rainer

Creating a % change calculation

Wed, 31 Mar 2010 12:53:35 GMT

Thanks that works well.

Is there a function to replace "Above" if I was using this in a table where the period ran across the top?

Here is an idea of wht I am hoping to acheive

Period	1		2		3		4		5		6
	Sales	Change	Sales	Change	Sales	Change	Sales	Change	Sales	Change	Sales	Change
	10	-	12	20.0%	14	16.7%	16	14.3%	18	12.5%	20	11.1%

Many Thanks

Jason

Creating a % change calculation

Wed, 31 Mar 2010 13:10:46 GMT

Jason,

see QV help and look for: before, after ....

Rainer