Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vikas_nandanwar
Contributor II

Addition of Calculated Field

Hi All,

I have my data in below

I need a calculated field in pivot giving result as -

[Sum 2016(USD) - Sum 2015(USD) ] / [Sum 2015(USD)]


Please help.

 

YearUSD 20152016Growth
20162000Sum of USD20700218005.02%
20162600
20162800
20163400
20163000
20166600
2016800
2016600
20155400
20154600
20154200
20152000
2015700
2015300
20152200
2015800
2015500

Regards,

Vikas

2 Replies
MVP
MVP

Re: Addition of Calculated Field

May be like this

Sum(USD)/Before(Sum(USD)) - 1

Where Year is pivoted at the top

vikas_nandanwar
Contributor II

Re: Addition of Calculated Field

Thanks Sunny.

This worked.

Community Browser