topic Expression in QlikView https://community.qlik.com/t5/QlikView/Expression/m-p/465021#M486686 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P> TGB = P * R</P><P></P><P>where P is the premium and r is the rate ,</P><P></P><P>but the expression below are all incorrect </P><P></P><P>=sum(P)*R&nbsp; returns nothing </P><P>=sum(P)*sum(R) bloats the figure</P></BODY></HTML> Thu, 21 Mar 2013 11:27:08 GMT Anonymous 2013-03-21T11:27:08Z Expression https://community.qlik.com/t5/QlikView/Expression/m-p/465021#M486686 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P> TGB = P * R</P><P></P><P>where P is the premium and r is the rate ,</P><P></P><P>but the expression below are all incorrect </P><P></P><P>=sum(P)*R&nbsp; returns nothing </P><P>=sum(P)*sum(R) bloats the figure</P></BODY></HTML> Thu, 21 Mar 2013 11:27:08 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/465021#M486686 Anonymous 2013-03-21T11:27:08Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/465022#M486687 <HTML><HEAD></HEAD><BODY><P>sum(P*R)?</P></BODY></HTML> Thu, 21 Mar 2013 11:28:18 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/465022#M486687 Gysbert_Wassenaar 2013-03-21T11:28:18Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/465023#M486688 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>use</P><P></P><P> =SUM(P*R)</P><P></P><P>it should work.</P><P></P><P>Regards,</P><P>anant</P></BODY></HTML> Thu, 21 Mar 2013 11:34:23 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/465023#M486688 Anonymous 2013-03-21T11:34:23Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/465024#M486689 <HTML><HEAD></HEAD><BODY><P></P><P>Hi,</P><P></P><P>You should use </P><P></P><P>=SUM(P*R)</P><P></P><P>for this.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 21 Mar 2013 11:41:29 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/465024#M486689 jagan 2013-03-21T11:41:29Z