Skip to main content
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Pivot table subtotal vizualization

Hi All,

I had a requirement to show  Subtotal for each department based on Associated category.

Sample O/P show as as below :


Is this way is possible in QlikView

Labels (1)
4 Replies

Yes, it is possible. Check the Presentation tab of the chart (make it a Pivot Table) and click on the corresponding field, then on "Show Partial Sums".
Partner - Contributor III
Partner - Contributor III

Yes its possible.Please see the below screenshot.


Hope it helps.




Contributor III
Contributor III

Earlier I did same thing what you suggest, I din't get my required output.

My question is,How to present Department and Category in a Single Column.


Former Employee
Former Employee

Hemanth, going out on a bit of a limb as we say, not sure the following is of any use, but thought it might give you some ideas here possibly:

There may be some other Design Blog posts that are better than this one as well, the following link will set you to the page where you can search things yourself:

Sorry I do not have anything better for you.


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.