Qlik Community

Qlik Sense App Development

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

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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:

image.png

 

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