Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Subtotal Field A at change of Field B

Hi all,

In a straight table chart, I have one column displaying Sales Order No (s_order) and another column displaying the Sales order Total Inc (order_total).

I need to display a subtotal for "order_total" at every change of "s_order".

can anyone direct me on how to achieve this?

Thanks in Advance!!

F.Giorgio

1 Solution

Accepted Solutions
rahulpawarb
Specialist III
Specialist III

Hello Fabrizio,

Thank you for sharing the required files.

To fix this issue I have shifted the BOrders Total inc & InPicking Total inc from dimensions tab to Expression tab.

Please refer attached modified application file.

Regards!

Rahul

View solution in original post

24 Replies
Anil_Babu_Samineni

Look at partial sum from presentation tab?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
vinieme12
Champion III
Champion III

Change your table to a pivot table and use Partial Sum option in the presentation tab for your field which you want see subtotals for

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
sunny_talwar

Above two suggestions are guiding you in the right direction, but for more help on this topic, share a small sample with the expected output.

Anonymous
Not applicable
Author

Hi Sunny,

Thanks for your input...

here's a simplified representation of what the output should look like...

Price subtotal at change in Sales Order No...

   

Customer AccSales Order NoProductPrice
Mr X123456Product A10
Mr X123456Product B20
Mr X123456Product C30
Price Subtotal60
Mr Y123457Product X5
Mr Y123457Product Y10
Mr Y123457Product Z15
Price Subtotal30

Is there a way this could be done in a straight table?


if not can a pivot table always display all fields as expanded?


thanks again for your assistance...


F.Giorgio

Anil_Babu_Samineni

Is there a way this could be done in a straight table?

Simply answer is No

if not can a pivot table always display all fields as expanded?

Yes, It would. Is that is okay for you. Same Thing straight table here you need to enable option from presentation tab called "Always Fully Expanded"

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
vinieme12
Champion III
Champion III

Partial Sums in straight table | Custom Labels in Pivot SubTotals

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

Hi Anil,

Sorry for the delayed reply, I only have time to work on this here and there...

I have now setup the report as a Pivot table and it looks great...

I have tried using the "Show Partial Sums" and I can roughly understand how this works however I can't get a subtotal of my Price at each change of SOrder...

Do I need to use the Sum(Price) expression and where do I put this in order for this to display under the price column?

If someone could let me know when you have a chance that would be appreciated...

Thanks.

F.Giorgio

Anil_Babu_Samineni

Good, Here you need to understand is how Partial Sum works

This is basic example to understand Partial Sums

For Editing the name, You could go like image, For your way this should run for "Sales Order"

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
Anonymous
Not applicable
Author

Hi Anil and all,

I appreciate everyone's help and I did look at all the advise and links provided, however I still cannot understand how to achive this.

Here's an exerpt from my actual report below.

What I am trying to achieve is a subtotal sum of BOrders Total Inc and In Picking Total Inc at the change of every S/Order.

The subtotal row is in the correct place, but I cannot understand how to display the subtotals in that row.

I am not sure if there are expressions involved to achieve this and where these expressions need to be applied.

Any help would be appreciated...

Thanks

Qlikview Subtotals.JPG