Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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?