1 Reply Latest reply: Jun 5, 2012 2:07 AM by jagan mohan rao appala RSS

    Expresion issue

      I have four column in my excel sheet

      flag

      calmonth

      amount

      Budget

       

      On the basis of amount and budget , i want a new column

       

      i am just uploading the excel sheet, where i have calculated new field (only few values). the formuala that is used in excel sheet. i want to reflect in qlikview on

      the basis of fiscal year(calmonth). That is when i select year and month, the values changes accordingly

        • Re: Expresion issue
          jagan mohan rao appala

          Hi,

           

          Use this script

           

          Temp:

          LOAD

              *,

              If(RowNo() = 1, Budget, (Amount - Previous(Budget))) AS Net;

          LOAD Flag,

               Calmonth,

               Amount,

               Budget

          FROM

          [C:\Documents and Settings\testuser\Desktop\Book1.xlsx]

          (ooxml, embedded labels, table is Sheet1)

           

          Or find file attached.

           

          Regards,

          Jagan.