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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
alanwong1178
Contributor III
Contributor III

Pivot table total of running differences

Region2013 2014 2015 2016  
/Current YearDiff vs LY Diff vs LYCurrent YearDiff vs LYCurrent YearDiff vs LYTotal differences
Japan50 100501202090-3040
Korea40 1208010-11080300
China70 50-2014090120-2050

 

I am working on a pivot table with region vs year. For the " Diff vs LY" , I used sum(sales)- before (sum(sales)).

For now, I need to find the sum of all "Diff vs LY" field  as total differences as highlighted in blue as above. 

May I know any method for that? or any method to calculate differences of sales between  latest year (2016)  - first year (2013) in the pivot table?

 

 

Labels (1)
1 Reply
Ksrinivasan
Specialist
Specialist

hi,

maxyear-2016,

minyear-2013

so, try this expression

sum({$<Year={'$(=max(Year))'}>} Sales)-sum({$<Year={'$(=Min(Year))'}>} Sales)

ksrini