Expresion issue

[#1]

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

[jagan]

Hi,

Use this script

Temp:

LOAD

    *,

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

LOAD Flag,

     Calmonth,

     Amount,

     Budget

FROM

(ooxml, embedded labels, table is Sheet1)

Or find file attached.

Regards,

Jagan.