Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

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
MVP & Luminary
MVP & Luminary

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))