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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
pete_bolin
Contributor
Contributor

Calculating a percentage change between two numbers in a pivot table

Capture.JPG

How do I calculate the percentage change between the totals and by each territory? So for example (126-140)/140=-10.00%

Thanks

1 Reply
sunny_talwar

May be try this

Count(Measure)/Before(Count(Measure)) - 1