Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
MVP
MVP

Re: Calculating % 2012 vs 2011

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

Re: Calculating % 2012 vs 2011

hai,

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

see the attachment

Not applicable

Re: Calculating % 2012 vs 2011

Got it, thanks!

Community Browser