How to find difference between two row values

Tue, 20 Sep 2011 06:04:34 GMT

I have data like In columns 2009 2010 2011

In rows Budget Allocated 30000 40000 50000

Amount spent 26000 46000 70000

i need Out put Like

I have data like In columns 2009 %change 2010 % change 2011 %change

In rows Budget Allocated 30000 - 40000 5% 50000 10%

Amount spent 26000 - 46000 10% 70000 25%

i need to find out %change between two year 2010 -2009in budget allocation and %change in amount spent Y-Y

Please help me

Regards,

Bala prasad

Re: How to find difference between two row values

Tue, 20 Sep 2011 07:37:58 GMT

You need to use something like this (set analysis)(

Sum({<Year={$(=Only(Year)) }>}AmountSpent)-Sum({<Year={$(=Only(Year)-1) }>}AmountSpent)) /Sum({<Year={$(=Only(Year)-1)}>}AmountSpent)

topic Re: How to find difference between two row values in QlikView

How to find difference between two row values

Re: How to find difference between two row values