Pivot table subtotal vizualization

[Hemanth458]

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

[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]

Yes its possible.Please see the below screenshot.

Hope it helps.

Regards,

Hamza

[Hemanth458]

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]

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