Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Hemanth458
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 :

Capture.PNG

Is this way is possible in QlikView

Labels (1)
4 Replies
Miguel_Angel_Baeyens

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".
hamzabob1
Partner - Contributor III
Partner - Contributor III

Yes its possible.Please see the below screenshot.

ss.PNG

Hope it helps.

 

Regards,

Hamza

Hemanth458
Contributor III
Contributor III
Author

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.

 

Brett_Bleess
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:

https://community.qlik.com/t5/Qlik-Design-Blog/Unbalanced-n-level-hierarchies/ba-p/1474325

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:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Sorry I do not have anything better for you.

Regards,
Brett

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.