Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
newqlik2017
Creator II
Creator II

Difference between two rows in a pivot table & display as columns

Capture.PNG

Chart 2 - Final - is the pivoted chart of Original (first) chart.

I need to create 3 columns on Final (second) chart displaying the difference between prior n current columns for ABC n DEF.
These columns need to be a:
1) Column 1 = Difference between 201606 n 201609 for ABC n DEF
2) Column 2 = Difference between 201609 n 201612 for ABC n DEF
3) Column 3 = Difference between 201612 n 201703 for ABC n DEF

Ideas, please ?

0 Replies