topic If or set analysis problem when multiply with cost in QlikView https://community.qlik.com/t5/QlikView/If-or-set-analysis-problem-when-multiply-with-cost/m-p/211269#M500066 <HTML><HEAD></HEAD><BODY><P>Hi Johan,</P><P>Does it work with an extra " ) " behind it? There is 1 missing.</P><P><BR />If not just try something like:</P><P>IF(Sorting='Yellow', Sum(Meters*Cost))<BR /><BR />That should work.</P></BODY></HTML> Tue, 12 Apr 2011 12:28:51 GMT Anonymous 2011-04-12T12:28:51Z If or set analysis problem when multiply with cost https://community.qlik.com/t5/QlikView/If-or-set-analysis-problem-when-multiply-with-cost/m-p/211268#M500065 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><BR />I have a Qlikview beginner problem;</P><P>Why is</P><P>Sum(Meters*Cost)</P><P>working but not</P><P>Sum(if(Sorting='Yellow', Meters*Cost)?</P><P>Is there a workaround for this?</P><P>BR</P><P>Johan</P></BODY></HTML> Tue, 12 Apr 2011 12:18:38 GMT https://community.qlik.com/t5/QlikView/If-or-set-analysis-problem-when-multiply-with-cost/m-p/211268#M500065 2011-04-12T12:18:38Z If or set analysis problem when multiply with cost https://community.qlik.com/t5/QlikView/If-or-set-analysis-problem-when-multiply-with-cost/m-p/211269#M500066 <HTML><HEAD></HEAD><BODY><P>Hi Johan,</P><P>Does it work with an extra " ) " behind it? There is 1 missing.</P><P><BR />If not just try something like:</P><P>IF(Sorting='Yellow', Sum(Meters*Cost))<BR /><BR />That should work.</P></BODY></HTML> Tue, 12 Apr 2011 12:28:51 GMT https://community.qlik.com/t5/QlikView/If-or-set-analysis-problem-when-multiply-with-cost/m-p/211269#M500066 Anonymous 2011-04-12T12:28:51Z If or set analysis problem when multiply with cost https://community.qlik.com/t5/QlikView/If-or-set-analysis-problem-when-multiply-with-cost/m-p/211270#M500067 <HTML><HEAD></HEAD><BODY><P>Thank You for a quick reply!</P><P>It worked, as a stated "beginners problem"=)</P><P>Thank you!</P></BODY></HTML> Tue, 12 Apr 2011 13:07:32 GMT https://community.qlik.com/t5/QlikView/If-or-set-analysis-problem-when-multiply-with-cost/m-p/211270#M500067 2011-04-12T13:07:32Z