topic Pivot table subtotal vizualization in QlikView

Pivot table subtotal vizualization

Hemanth458 — Sat, 16 Nov 2024 02:55:23 GMT

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

Re: Pivot table subtotal vizualization

Miguel_Angel_Baeyens — Wed, 24 Jul 2019 11:38:31 GMT

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".

Re: Pivot table subtotal vizualization

hamzabob1 — Wed, 24 Jul 2019 12:07:50 GMT

Yes its possible.Please see the below screenshot.

Hope it helps.

Regards,

Hamza

Re: Pivot table subtotal vizualization

Hemanth458 — Wed, 24 Jul 2019 12:28:10 GMT

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.

Re: Pivot table subtotal vizualization

Brett_Bleess — Mon, 19 Aug 2019 13:44:40 GMT

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