Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Fiscal year period growth?

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

Please assist me on my initial query!

Not applicable

Re: Fiscal year period growth?

nobody?

Not applicable

Re: Fiscal year period growth?

My guess is:

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

Not applicable

Fiscal year period growth?

You can check this to get a better idea:

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

Community Browser