Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

Tags (2)
1 Solution

Accepted Solutions
Not applicable

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

3 Replies
sujeetsingh
Honored Contributor III

Re: Growth Calculation

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

Not applicable

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

qlikviewforum
Contributor II

Re: Growth Calculation

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

Community Browser