Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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
Partner

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
Support (Former)
Support (Former)

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.