Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

pete_bolin
New 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

Re: Calculating a percentage change between two numbers in a pivot table

May be try this

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

Community Browser