Qlik Community

App Development

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Keitaru
Creator
Creator

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)
  • pivot

0 Replies