topic Re: Help with expression in QlikView https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/397530#M148067 <HTML><HEAD></HEAD><BODY><P>FYI</P></BODY></HTML> Mon, 03 Dec 2012 02:41:25 GMT NZFei 2012-12-03T02:41:25Z Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/397529#M148066 <HTML><HEAD></HEAD><BODY><P>HI All,</P><P></P><P></P><P>I am trying to achive expression value but failing.... i am able to achive same result in excle but not in qlikview </P><P></P><P>Appreciate any help on this ... Please find attached Qvw and Source file </P><P></P><P>Thanks</P></BODY></HTML> Mon, 03 Dec 2012 00:03:25 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/397529#M148066 2012-12-03T00:03:25Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/397530#M148067 <HTML><HEAD></HEAD><BODY><P>FYI</P></BODY></HTML> Mon, 03 Dec 2012 02:41:25 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/397530#M148067 NZFei 2012-12-03T02:41:25Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/397531#M148068 <HTML><HEAD></HEAD><BODY><P> You are loading G and H values from excel ....i am trying to achive those values in Qlikview </P></BODY></HTML> Mon, 03 Dec 2012 04:01:53 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/397531#M148068 2012-12-03T04:01:53Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/397532#M148069 <HTML><HEAD></HEAD><BODY><P>Found Solution ... </P><P></P><P><STRONG>Expression for Gn </STRONG></P><P>= </P><P>sum</P><P>(</P><P>(B) * C</P><P>/</P><P>(1-(C)) </P><P>) </P><P></P><P><STRONG>Expression for Hn </STRONG></P><P>= sum</P><P>(</P><P>(B) * C</P><P>/</P><P>(1-(C))</P><P>)</P><P>/</P><P>(</P><P>sum</P><P>(</P><P>(B)</P><P>/</P><P>(1-(C))</P><P>)</P><P>)</P></BODY></HTML> Mon, 03 Dec 2012 04:07:28 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/397532#M148069 2012-12-03T04:07:28Z