0 Replies Latest reply: Apr 23, 2013 1:30 AM by Tushar Suvarna RSS

    Need help in a complex expression(Converting Excel formulae to expressions)

    Tushar Suvarna

      Hi ,

       

      I have a excel sheet which contains data of which one coloum is calculated based on the previous coloumn value with a formule

      =1+SUM(B5:B$12)/SUM(B$2:B3)   where  B represents  the previous coloumn  . I trying to replicate the same sheet in qlikview pivot object .

       

      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 .

       

      Can any one help me or is this even possible in qlikview application ?

       

      Regards

       

      Tushar