9 Replies Latest reply: Oct 10, 2011 6:57 AM by gboyland RSS

    Excel like reporting in Qlikview - Row 3 = Row 1 - Row 2

      Hi,

      I want to replicate a excel report in qlikview. Data comes from Oracle, previous they were manually computing it in Excel now i have to replace that manual computing in qlikview.

      For example:

      Row 1 is Income

      Row 2 is Expenditure

      Row 3 = Income - Expenditure

      Row 4 is Depreciation

      Row 5 = Row3 - Row4

      I have also attached the excel sheet of what i'm trying to say.

      Please help me.

       

       

      Thanks

      Widaad

       

      Inmonth
      BudgetActualVariance
      Income500550-50
      Expenditure45040050
      EBITDAIncome - Expenditre
      ITD5055-5
      Depreciation45405
      Before IFRIC12ITD - Depreciation
      IFRIC1240400
      After IFRIC12Before IFRIC12 - IFRIC12


       

      Thanks

      Widaad