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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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!