Problem with the summate in set analysis

geogou1973 — Thu, 16 Sep 2021 16:02:50 GMT

Hello,

i have the following expression that summate (if the weighed item (QTY_VAR) = 0) the fragmentary item (QTY) +

(if the weighed item (QTY_VAR) <> 0) the weighed item (QTY_VAR) and all that multiplies with the COST

(sum({<ITEM={"=sum(QTY_VAR)=0"}>} QTY)
+sum({<ITEM={"=sum(QTY_VAR)<>0"}>} QTY_VAR))*COST

The chart is configurable , the user choices fields from a table and the chart show the fields e.g if i choose the ITEM the formula gives the correct results but if i choose the STORE the results are different .

How can i have the correct results for all the fields as the field ITEM ;

Thank you in advanced.

topic Problem with the summate in set analysis in QlikView

Problem with the summate in set analysis