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

    Growth Calculation

      Hi Qliker Experts!

       

      I have this table:

       

      CityYearPopulation
      Jakarta20101,000,000
      Madrid2010500,000
      Prague2010150,000
      Melbourne2010700,000
      Jakarta20111,072,486
      Madrid2011535,836
      Prague2011154,237
      Melbourne2011726,029
      Jakarta20121,107,510
      Madrid2012544,556
      Prague2012158,301
      Melbourne2012755,129

       

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

       

      CityYearPopulationGrowthGrowth_Percent
      Jakarta20101,000,000                                      -  0
      Madrid2010500,000                                      -  0
      Prague2010150,000                                      -  0
      Melbourne2010700,000                                      -  0
      Jakarta20111,072,486 72,486 7.25
      Madrid2011535,836 35,836 7.17
      Prague2011154,237 4,237 2.82
      Melbourne2011726,029 26,029 3.72
      Jakarta20121,107,510 35,024 3.27
      Madrid2012544,556 8,720 1.63
      Prague2012158,301 4,064 2.63
      Melbourne2012755,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?

       

      Growth.PNG

       

       

      Any help is appreciated.

      Thank you.

       

      A