https://community.qlik.com/t5/App-Development/Pivot-Table-Change-Calculation/m-p/1698132#M53439 <P>Figured it out. I needed to add parenthesis around first expression.<BR /><STRONG>(</STRONG>(count(distinct XX) - after(count(distinct XX)))<STRONG>)</STRONG> / after(count(distinct XX))</P> Thu, 30 Apr 2020 14:24:09 GMT dbmetcalf 2020-04-30T14:24:09Z https://community.qlik.com/t5/App-Development/Pivot-Table-Change-Calculation/m-p/1697904#M53416 <P>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:<BR /><STRONG><BR />count(distinct XX) - after(count(distinct XX))</STRONG></P><P>Here are the results of the above expression below. Any suggestions?</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/32689i924512D9E9A45BA9/image-size/medium?v=v2&amp;px=400" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P> Sat, 16 Nov 2024 18:42:48 GMT https://community.qlik.com/t5/App-Development/Pivot-Table-Change-Calculation/m-p/1697904#M53416 dbmetcalf 2024-11-16T18:42:48Z https://community.qlik.com/t5/App-Development/Pivot-Table-Change-Calculation/m-p/1698132#M53439 <P>Figured it out. I needed to add parenthesis around first expression.<BR /><STRONG>(</STRONG>(count(distinct XX) - after(count(distinct XX)))<STRONG>)</STRONG> / after(count(distinct XX))</P> Thu, 30 Apr 2020 14:24:09 GMT https://community.qlik.com/t5/App-Development/Pivot-Table-Change-Calculation/m-p/1698132#M53439 dbmetcalf 2020-04-30T14:24:09Z