Set analysis total

[coco_manel]

Hello, i have a measure in qlik which divides eg:  the quantity / price. The problem is that the total in a table is showing the value wrong, but if i take for example row by row and sum this measure output up the total is the correct one, also when i put it in a KPI card it`s showing the wrong value. What can i also tell you about these two field is that they were in two separates tables, on which i performed a join based on ID. If you could help me solve this would be perfect.

[TheoAtragie]

Do you have NA values?

[coco_manel]

Hello, no NA values found actually.

[coco_manel]

Actually looking there are some NULL values which i found, could be from this?

[TheoAtragie]

Oui, excluez les dans le set analysis

[marcus_sommer]

You may need a nested aggregation like:

avg(aggr(sum(quantity) / sum(price), Dim1, Dim2))

whereby Din1 and Dim2 are placeholder for the needed dimensionality in which the calculation should be performed (usually the object-dimensions).