Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

3 Replies
sujeetsingh
Master III
Master III

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

Not applicable
Author

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
Creator II
Creator II

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