topic Re: Excel formula in Qlikview in QlikView https://community.qlik.com/t5/QlikView/Excel-formula-in-Qlikview/m-p/472178#M176327 <HTML><HEAD></HEAD><BODY><P>Try this expression:</P><P></P><P>1+rangesum(below(total sum([Policy Count]),1,61-RowNo(TOTAL)))/ rangesum(above(total sum([Policy Count]),0,RowNo(TOTAL)))</P><P></P><P>See attached qvw. </P></BODY></HTML> Sat, 18 May 2013 08:17:52 GMT Gysbert_Wassenaar 2013-05-18T08:17:52Z Excel formula in Qlikview https://community.qlik.com/t5/QlikView/Excel-formula-in-Qlikview/m-p/472177#M176326 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp; Can anyone help me out with this formula. Column C (factor) in the attached excel is calculated from A and B. the formula is </P><P></P><P>1+SUM(B3:B$62)/SUM(B$2:B2).</P><P></P><P>Please check and let me know if this is possible in Qlikview and how it can be achieved.</P><P></P><P></P><P>Thanks in advance.</P><P>Lax</P></BODY></HTML> Sat, 18 May 2013 08:03:37 GMT https://community.qlik.com/t5/QlikView/Excel-formula-in-Qlikview/m-p/472177#M176326 2013-05-18T08:03:37Z Re: Excel formula in Qlikview https://community.qlik.com/t5/QlikView/Excel-formula-in-Qlikview/m-p/472178#M176327 <HTML><HEAD></HEAD><BODY><P>Try this expression:</P><P></P><P>1+rangesum(below(total sum([Policy Count]),1,61-RowNo(TOTAL)))/ rangesum(above(total sum([Policy Count]),0,RowNo(TOTAL)))</P><P></P><P>See attached qvw. </P></BODY></HTML> Sat, 18 May 2013 08:17:52 GMT https://community.qlik.com/t5/QlikView/Excel-formula-in-Qlikview/m-p/472178#M176327 Gysbert_Wassenaar 2013-05-18T08:17:52Z