Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 - Champion III
Partner - Champion III

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!