topic How to use Sum with If in QlikView

topic How to use Sum with If in QlikView https://community.qlik.com/t5/QlikView/How-to-use-Sum-with-If/m-p/430379#M561383 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I am new at QV!</P><P></P><P>When I try to do an chart with following expression I get wrong figure. Could somebody help me, what I done wrong?</P><P></P><P>sum(Sales)                                                  = 100 <SPAN style="color: #ff0000;">Correct</SPAN></P><P><SPAN style="color: #000000;">sum(if(BuyingFunction = '1',Sales))             = 120 <SPAN style="color: #ff0000;">Not correct, should be 80, because we have other BuyingFunction. How can it be mor than 100?</SPAN></SPAN></P></BODY></HTML> Mon, 08 Apr 2013 08:36:28 GMT 2013-04-08T08:36:28Z How to use Sum with If https://community.qlik.com/t5/QlikView/How-to-use-Sum-with-If/m-p/430379#M561383 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I am new at QV!</P><P></P><P>When I try to do an chart with following expression I get wrong figure. Could somebody help me, what I done wrong?</P><P></P><P>sum(Sales)                                                  = 100 <SPAN style="color: #ff0000;">Correct</SPAN></P><P><SPAN style="color: #000000;">sum(if(BuyingFunction = '1',Sales))             = 120 <SPAN style="color: #ff0000;">Not correct, should be 80, because we have other BuyingFunction. How can it be mor than 100?</SPAN></SPAN></P></BODY></HTML> Mon, 08 Apr 2013 08:36:28 GMT https://community.qlik.com/t5/QlikView/How-to-use-Sum-with-If/m-p/430379#M561383 2013-04-08T08:36:28Z