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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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
Partner - Master II
Partner - Master II

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