Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Rajesh
Creator II
Creator II

Percentage of row total

Hi All,

I am trying to do Percentage of row total in pivot table, but not getting, any one can plz suggest

my Dimensions NG Category, Type and Expression is Count(NG Category)

Please see below image which is done in Excel Pivot tabel using % rows total option.

Capture.PNG

Thanks

Rajesh

3 Replies
Anil_Babu_Samineni

Please provide sample data

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
devarasu07
Master II
Master II

Hi,

what is the issue here?, Just enable the Partial sum on Type Dimension at chart Presentation tab

Capture.JPG

qliksus
Specialist II
Specialist II

Are you not using the aggregation function ?  because only in that case you wont have the total displayed even when you select Partial Sum option