Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
bhaveshp90
Creator III
Creator III

How to get subtotals for the shown matrix?

Hello,

I have the pivot table as shown below;

Screenshot (5).png

How to get the subtotals for Header1 (subtotals for Order Entry Cal, subtotals for Upd.OEC, etc).

I could not able to get it when I enabled the "Show Partial Sum" in the presentation tab,

This is the image I got, how to get individual subtotals for Order Entry Calc, Upd.OEC, etc?


Screenshot (5).png

thanks

Bhavesh

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Check if that helps?

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

5 Replies
chrismarlow
Specialist II
Specialist II

Bhavesh,

What number would you be adding to 58.516 (for example) to get your subtotal for Order Entry Cal?

Regards,

Chris.

vishsaggi
Champion III
Champion III

Did you try checking Show partial sums for the field header1 ? Can you share snapshot of what you see when you check for header1 and uncheck other fields that has show partial sum.

Anil_Babu_Samineni

Check if that helps?

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

bhaveshp90
Creator III
Creator III
Author

that was helpful, thank you

chrismarlow
Specialist II
Specialist II

Bhavesh,

I can't open Anil's attachment, so please ignore if I have misunderstood, but as an accountant (who pretends to be a geek, or vice versa which ever way the wind is blowing), you would not add Sales & Cost of Sales (& the others) together like that. So;

Gross Profit=Sales-Cost Of Sales

Gross Profit as Percentage of Sales =Gross Profit/Sales (i.e. your 23 is 23%)

and so on ...


That is why I asked what you intended to add the 58.516 to, as not sure how it makes sense (again, unless I've misunderstood). It would make sense to add together for regions, but then that is going to be messy given the order of the dimensions.


Regards,


Chris.