percentage change over year/month

[#1]

Hi there,

I have created a pivot table sheet object.

How can i add an expression for Sales to show the % change for year-on-year?

As in below:

Month	2014	2015	% Chng
1	67,702	72,170	7%
2	57,057	62,895	10%
3	78,587	76,086	-3%
4	78,795	78,463	0%
5	77,622	79,552	2%
6	71,801	76,178	6%
7	77,978	71,959	-8%
8	76,734	70,606	-8%
9	75,039	74,484	-1%
10	82,975	81,524	-2%
11	78,675	78,233	-1%
12	18,042	17,889	-1%

[Anonymous]

try like this:

=(sum of sales of 2015 - sum of sales of 2014) / sum of sales of 2014

[Anonymous]

In QV, you can write expression for Current Year and Previous Year like:

Current Year(2015): =sum({<YearField=, YearField={'$(=max(YearField)'}>} Sales)

Previous Year(2014): =sum({<YearField=, YearField={'$(=max(YearField)-1'}>} Sales)

[#4]

Hi,

like this in the pic...not working??

!

[Anonymous]

My Dear, you just need to write exprssion not full statement...It seems you are novice user...

Please see :

How should i learn basic of qlikview ?

QlikView Training Videos

[Anonymous]

write this part only in expression:

=sum({<YearField=, YearField={'$(=max(YearField)'}>} Sales)

and replace YearField & Sales with your fields

[sunny_talwar]

Check this out:

Expression:

=If(SecondaryDimensionality() = 0, Num(Sum({<Year = {'$(=Max(Year))'}>} Data)/Sum({<Year = {'$(=Max(Year) - 1)'}>} Data) - 1, '0%'), Sum(Data))

[#8]

Hi

I cant open your file, Qlikview give me exceed number of max recoveries , need license.

I tried insert the expression but get no % change.

Pls see attached.

[sunny_talwar]

you need to enable partial sum on the presentation tab:

[#10]

Hi

Thanks, i got it.

But how set the 2014 and 2015 as Integer only.