Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
kishorj1982
Creator II
Creator II

How to make the sum of three columns having cumulative data in qlikview pivot table

How to make the sum of three columns having cumulative data in qlikview pivot table  

15 Replies
kishorj1982
Creator II
Creator II
Author

Hi Anil,

PFA.

In attachment I am not able to show total.

For total rowis other expression. and for rest other exp.

Please suggest

Anil_Babu_Samineni

Sorry, I don't have Qlikview software

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
kishorj1982
Creator II
Creator II
Author

Attached is screenshot,

Irrespective of selecting show partial sum in pivot table total row is not displayed for my expression in pivot table.

For total row my exp is different.

But I do not know how to show it.

thanks

Anil_Babu_Samineni

Try to enable "Partial Sum" option for "Branch_Plant"

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
kishorj1982
Creator II
Creator II
Author

done but no luck

pradosh_thakur
Master II
Master II

something like this?

Learning never stops.