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: 
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))