Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incorrect Sum from Measure

I have a measure that shows us the weight of products sold per order, but when used in pivot table, the total sum is shown incorrectly.  Has anyone experienced this issue previously?  If so, what is a possible solution so that the correct total weight is shown?  Below is expression I am using:

SUM(aggr(Sum(distinct (weight_base / 1000000) * qty_base), order_product_inventory_id))

Thanks in advance for help.

2 Replies

Maybe there are further dimensions within the pivot which aren't covered within the aggr().

- Marcus


May be:

=SUM(aggr(Sum(weight_base / 1000000) * only(qty_base), order_product_inventory_id,Field2))