Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 

Problem with the summate in set analysis


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.


0 Replies