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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Percentage difference between two columns in a pivot table

Hello, I need your help again!

Please see the attached example document. How can I add a column to my pivot table that shows the percentage difference between the two years?

Thanks

James

1 Solution

Accepted Solutions
Not applicable
Author

Hello James,

I have used the set analysis in order to do what you want. See the attached document.

If you have any question, I remain at your disposal.

Regards,

Amand

View solution in original post

2 Replies
Not applicable
Author

Hello James,

I have used the set analysis in order to do what you want. See the attached document.

If you have any question, I remain at your disposal.

Regards,

Amand

Not applicable
Author

That's great, thanks for your help!