Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

pivot table naming issue

Hello Team,

i have created Pivot table to with two dimensions, i have added partial sum for one dimension, i could see total name reflecting twice in pivot table twice(please refer below screenshot). kindly suggest me how to remove duplicate sub total name.

remove one total.png

Thanks in Advance,

2 Replies
Former Employee
Former Employee

Really need the QVW file on this one to try to help you, if you have sensitive field info, you can use the Settings\Document Properties\Scrambling tab to scramble that information prior to posting.  Folks need to be able to see the chart properties and data model in order to be able to try to determine what may be occurring here.


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Specialist II
Specialist II

please check partial sums checkbox for your dimensions:

Right click diagram > properties

presentation tab > choose dimensions one by one and check checkbox "show partial sums"