Skip to main content

App Development

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ismqui00
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
marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus

balabhaskarqlik

May be:

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