Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating % 2012 vs 2011

I have 2 expressions sum({$<Year={2011}>}[Billed Amount USD]) and sum({$<Year={2012}>}[Billed Amount USD]), how can i calculate the % that expresses 2012 vs 2011?

3 Replies
jonathandienst
Partner
Partner

Hi

The % increase could be expressed:

(sum({$<Year={2012}>}[Billed Amount USD]) - sum({$<Year={2011}>}[Billed Amount USD])) / sum({$<Year={2011}>}[Billed Amount USD])

Hope that helps

Jonathan

PS: Check the display as % option on the number tab of the chart proprties

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

hai,

use (current-previous/current )  and use relative option   in straight table  so you will get the variance.

see the attachment

Not applicable
Author

Got it, thanks!