Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

brittanyalong
New Contributor

Year over Year % Change

I've been struggling to calculate % change between years/months so that it can change dynamically. I know how to hard code the years in, but want to see the % changes across multiple years. Here is an example of my data set:

   

MonthYearValue
120154
220158
320155
420151
520156
620158
720154
820155
920158
1020157
1120154
1220155
120165
220164
320168
420162
520166
620164
720161
820165
920166
1020164
1120162
1220166
120174
220172
320176
420174
520172
620175
720171
820172
920177
1020176
1120175
1220175

I currently have a pivot table on a sheet that looks like this using =Sum(Value)

   

201720162015
Value495365

I'm trying to get to this without having to hard code the years into the set analysis formula:

   

201720162015
Value % Change-8%-23%0
1 Solution

Accepted Solutions
MVP
MVP

Re: Year over Year % Change

Try this

Sum(Value)/After(Sum(Value)) - 1



Capture.PNG

3 Replies
MVP
MVP

Re: Year over Year % Change

Try this

Sum(Value)/After(Sum(Value)) - 1



Capture.PNG

praveenkumar_ma
Contributor

Re: Year over Year % Change

Hi Brittany,

Try this Just in Case.

Sum(Value)/ (Sum(Total Value))

Thanks

PM

brittanyalong
New Contributor

Re: Year over Year % Change

Worked perfectly! Thank you!!!