topic Need help in a complex expression(Converting Excel formulae to expressions) in QlikView https://community.qlik.com/t5/QlikView/Need-help-in-a-complex-expression-Converting-Excel-formulae-to/m-p/387947#M485908 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I have a excel sheet which contains data of which one coloum is calculated based on the previous coloumn value with a formule </P><P>=1+SUM(B5:B$12)/SUM(B$2:B3)&nbsp;&nbsp; where&nbsp; B represents&nbsp; the previous coloumn&nbsp; . I trying to replicate the same sheet in qlikview pivot object .</P><P></P><P>I am not been able to found the solution to this formulae in expression . I am attaching the sample application as well as the Excel sheet which contains the report which i want to replicate in qlikview .</P><P></P><P>Can any one help me or is this even possible in qlikview application ?</P><P></P><P>Regards </P><P></P><P>Tushar</P></BODY></HTML> Tue, 23 Apr 2013 05:23:56 GMT 2013-04-23T05:23:56Z Need help in a complex expression(Converting Excel formulae to expressions) https://community.qlik.com/t5/QlikView/Need-help-in-a-complex-expression-Converting-Excel-formulae-to/m-p/387947#M485908 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I have a excel sheet which contains data of which one coloum is calculated based on the previous coloumn value with a formule </P><P>=1+SUM(B5:B$12)/SUM(B$2:B3)&nbsp;&nbsp; where&nbsp; B represents&nbsp; the previous coloumn&nbsp; . I trying to replicate the same sheet in qlikview pivot object .</P><P></P><P>I am not been able to found the solution to this formulae in expression . I am attaching the sample application as well as the Excel sheet which contains the report which i want to replicate in qlikview .</P><P></P><P>Can any one help me or is this even possible in qlikview application ?</P><P></P><P>Regards </P><P></P><P>Tushar</P></BODY></HTML> Tue, 23 Apr 2013 05:23:56 GMT https://community.qlik.com/t5/QlikView/Need-help-in-a-complex-expression-Converting-Excel-formulae-to/m-p/387947#M485908 2013-04-23T05:23:56Z