Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Fiscal year period growth?

Hello,

I have following data by fiscal year (start from 1 may - 30 April)

Fiscal Year      Field 1       Field 2

2011-2012      355             324

2010-2011     202876        436022

2009-2010     143611        384326

2008-2009     50369          136769

Q: how do i calculate fiscal period over period % growth?

Hope anyone can help me out!

Thanks 

4 Replies
Not applicable
Author

sorry, i would like to make % growth based on Field 2 (above example)

Please assist me on my initial query!

Not applicable
Author

nobody?

Not applicable
Author

My guess is:

=([Field 1]-below([Field 1]))/below([Field 1])

Not applicable
Author

You can check this to get a better idea:

http://community.qlik.com/message/8290#8290