Qlik Community

Qlik Sense App Development

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

Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Calculate Percentage in pivot Table

I have a pivot table which i want the content value to be changed from a numeric value to a Percentage value:



Total: to show total % value

Miss TRO in % value across the months

Within TRO in % value across the months.

How do I achieve this?

if tried the following but it doesn't work

Count( {<[Status*]-={'Closed','Cancelled','Draft'}>} Distinct ID) /
Count( {<[Status*]-={'Closed','Cancelled','Draft'}>} Total  [ID*+])

Labels (1)
0 Replies