Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to calc % change from calculated expressions?

Hello - relatively new to QV.  I'm trying to figure out how to calculate a growth metric (% growth from prior year for example) for selected fields within qv.  I created a couple simple charts (attached) from an excel data source, where the data from excel is organized as follows (example has three years of data through 2010):

CountryYear Units Revenue Region
US2008     1,000.00            1,000.00 N AMERICA
Canada2008         200.00                180.00 N AMERICA
UK2008         300.00                180.00 EUROPE
Spain2008         350.00                262.50 EUROPE
Italy2008         275.00                206.25 EUROPE

How can I calculate year over year % changes in units and revenues for selected fields?  Within the attached, if you filter on "N America", you would see revenues of 1180, 1330 & 1406.9 for 2008-2010 respectively.  I would like to calc and show the growth metrics of 12.7% (2008 - 1180 to 2009 - 1330) and 5.8% (2009 - 1330 to 1406.9) for 2009 and 2010.

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to calc % change from calculated expressions?

See attached qvw. Is that close to what you're looking for?


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to calc % change from calculated expressions?

See attached qvw. Is that close to what you're looking for?


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Not applicable

Re: How to calc % change from calculated expressions?

Thanks Gysbert, exactly what I needed.  Of course it's this simple - I appreciate the help! 

Highlighted
Not applicable

Re: How to calc % change from calculated expressions?

Sorry for the bother, but just to piggy back off of this question - is there a way to create analyses by utilizing the % growth as the basis?  For example (and using the attached) is there a way I could list the top 3 countries that had the largest % revenue growth from 08 to 09?  09-10?  Or even 08 to 10?