Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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_michaelid
Not applicable

Total values missing in Pivot

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
Not applicable

Total values missing in Pivot

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