7 Replies Latest reply: Aug 5, 2014 8:18 PM by Marco Wedel RSS

    Calculation

    Dinesh Reddy Seelam

      Hello All,

       

      I need a annual calculation, the following was done in excel is it possible in straight or pivot table in qlik ?

       

      If so  in the annual column below each row is achieved by using this formula  FOR C5 ROW = ((B5-B4)/(A5-A4))*365

       

       

      ABC
      1DateReadingAnnual
      205/04/121,403,817
      306/13/12388,8880
      407/11/121,458,2500
      508/21/121,487,134257,809
      609/23/121,505,500200,370
      710/15/121,525,153332,586
      811/16/121,553,282320,117
      912/19/121,577,608269,649
      1001/17/131,597,829254,955