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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
carlcimino
Luminary
Luminary

Difference Metric on Pivot Table

Hello I have a Pivot Table with one measure (WP) and I have it broken out by a dimension (SOURCE).  Is there a way to show the difference between the two without creating WP metric for each source?
Pivot.jpg

Labels (2)
1 Solution

Accepted Solutions
Anil_Babu_Samineni

I apologies for late respond, Is this what you are expecting?

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

5 Replies
Anil_Babu_Samineni

Yes, we can do. Please attach sample data set
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
carlcimino
Luminary
Luminary
Author


DATA:
load * Inline [
ACCT_D,SOURCE,WP
201601,BAR,10
201602,BAR,20
201603,BAR,30
201604,BAR,40
201605,BAR,50
201606,BAR,60
201607,BAR,70
201608,BAR,80
201609,BAR,90
201610,BAR,100
201611,BAR,1110
201612,BAR,123
201601,CMR,1110
201602,CMR,123
201603,CMR,100
201604,CMR,90
201605,CMR,80
201606,CMR,70
201607,CMR,60
201608,CMR,50
201609,CMR,40
201610,CMR,30
201611,CMR,20
201612,CMR,10];

exit script;

carlcimino
Luminary
Luminary
Author

Hello, Anything on this?  

Anil_Babu_Samineni

I apologies for late respond, Is this what you are expecting?

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
carlcimino
Luminary
Luminary
Author

Yes, thank you very much.