Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
may be this is not to the point but yes You can get an idea from this sample
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
Can you please attach the sample application which contains this chart?