3 Replies Latest reply: Nov 6, 2013 5:34 AM by Rikab Kothari

# Growth Calculation

Hi Qliker Experts!

I have this table:

 City Year Population Jakarta 2010 1,000,000 Madrid 2010 500,000 Prague 2010 150,000 Melbourne 2010 700,000 Jakarta 2011 1,072,486 Madrid 2011 535,836 Prague 2011 154,237 Melbourne 2011 726,029 Jakarta 2012 1,107,510 Madrid 2012 544,556 Prague 2012 158,301 Melbourne 2012 755,129

ready to be loaded into QV, and I kinda wonder how can I calculate while loading so that I will get this table:

 City Year Population Growth Growth_Percent Jakarta 2010 1,000,000 - 0 Madrid 2010 500,000 - 0 Prague 2010 150,000 - 0 Melbourne 2010 700,000 - 0 Jakarta 2011 1,072,486 72,486 7.25 Madrid 2011 535,836 35,836 7.17 Prague 2011 154,237 4,237 2.82 Melbourne 2011 726,029 26,029 3.72 Jakarta 2012 1,107,510 35,024 3.27 Madrid 2012 544,556 8,720 1.63 Prague 2012 158,301 4,064 2.63 Melbourne 2012 755,129 29,100 4.01

That's the FIRST question.

And the SECOND is:"How can I create this Growth Chart within QV?"

Is it possible?

Any help is appreciated.

Thank you.

A

• ###### Re: Growth Calculation

may be this is not to the point but yes You can get an idea from this sample

• ###### Re: Growth Calculation

Found it!

Just use function above()

Growth_Percent = (Growth - above(Growth)) / above(Growth)

Make sure that all dimensions and expressions you defined sorted in the same order.

Ciao!

A

• ###### Re: Growth Calculation

Can you please attach the sample application which contains this chart?