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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot Table Values As Percentage


Hi all,

Please refer to the attached screenshot.

I am trying to work out how I can show the values this pivot table as a percentage of the total row number.
E.g. in the first row, I would like to see value 29/1520, to give 1.9%

That value 29 is an expression setup in the pivot table.

Any help would be much appreciated.

Thanks

10 Replies
Not applicable
Author

Thanks Jeremiah, managed to work this out in the end.
So the solution was to use your dimensions in the <DIM1> values.

Much appreciated!