Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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

24 Replies
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

Anonymous
Not applicable
Author

Hi Rahul,

thanks for your response - I can't see an attachment though...

where do I see the modified file?

Thanks - Fab

rahulpawarb
Specialist III
Specialist III

Please refer my earlier thread (Same as prior mentioned screenshot).

Regards!

Rahul

Anonymous
Not applicable
Author

OK I can see it now...

sorry about that...

still getting familiar with this website...

That fixed my issue!! Thank you so much for your help!!!

Appreciate you sticking by us until the issue was resolved!!

rahulpawarb
Specialist III
Specialist III

Cheers,

Rahul