Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculating Sub-Total in a Straight Chart Table with Component

Hi 

I have a straight table with sub-totals , however I am stuggling to calculate the sub-totals for all the columns in the table

I have posted a similar discussion recently , but only this time each field is multiplied  by a component quantity.

Please can you assist calculating the sub-total.

kind regards

Nayan

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

Please put your last parenthesis after Componet Qty for each expression

=SUM({<[MonthIndex]={'$(vMaxMIMinus4)'}>}[Sales Quantity]*[Component Qty])

View solution in original post

2 Replies
Clever_Anjos
Employee
Employee

Please put your last parenthesis after Componet Qty for each expression

=SUM({<[MonthIndex]={'$(vMaxMIMinus4)'}>}[Sales Quantity]*[Component Qty])

Not applicable
Author

Thank you Clever.  Much appreciated.

kind regards

Nayan