Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total values missing in Pivot

Hello Community,

may one of you can help me.

I have a pivot table and use "show Partial Sums".

I get the Partial Sums for all values in the dimension,but for one it is missing.

Do you have an idea?

examle.png

sample.png

Regards,

Lukas

2 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

Do you have a dimension or expression without a label?  If so make sure you select the "blank" row in the Dimensions and Expressions setting in your PIVOT TABLE PROPERTIES AND select Show Partial Sums for everything.

Hope this helps,

Jason

v_iyyappan
Specialist
Specialist

Hi,

Please attach a sample file if u change straight table u will get answer.

Chart - > Propertities ->Total Mode -> Sum and Presentattion its may helpful.

Regards,

Iyyappan