Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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
Highlighted
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!

Highlighted
Not applicable

Re: Fiscal year period growth?

nobody?

Highlighted
Not applicable

Re: Fiscal year period growth?

My guess is:

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

Highlighted
Not applicable

Fiscal year period growth?

You can check this to get a better idea:

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