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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
dbmetcalf
Contributor II
Contributor II

Pivot Table % Change Calculation

I created a pivot table (below) to compare Year over Year counts of items. I used the following expression to find the difference between counts, but can't figure out how to get the percent difference:

count(distinct XX) - after(count(distinct XX))

Here are the results of the above expression below. Any suggestions?

 

Capture.PNG

Labels (2)
1 Solution

Accepted Solutions
dbmetcalf
Contributor II
Contributor II
Author

Figured it out. I needed to add parenthesis around first expression.
((count(distinct XX) - after(count(distinct XX)))) / after(count(distinct XX))

View solution in original post

1 Reply
dbmetcalf
Contributor II
Contributor II
Author

Figured it out. I needed to add parenthesis around first expression.
((count(distinct XX) - after(count(distinct XX)))) / after(count(distinct XX))