Skip to main content
Announcements
New: No-code data prep in Qlik Cloud Analytics™ TAKE A TOUR
cancel
Showing results for 
Search instead for 
Did you mean: 
samuel_lin
Creator
Creator

Qliksense Pivot Table, Row(?) percentage instead of counts

Hello Qliker!!

I have a pivot table that looks like:

Capture.PNG

The expression for counts right  now is very simple, it's just count(distinct EmailAddress)

I want to replace, but unsuccessful so far, counts to % of the row. For example, for row #1 '0X~3X', each column should be about 10%, the first one under high is 10,307/97,373 and so forth.

Any idea how I can achieve this?

Thanks!

Samuel

10 Replies
sebastianolivar
Contributor II
Contributor II

Thanks !!!