topic Expresion issue in QlikView

Expresion issue

Tue, 05 Jun 2012 05:26:35 GMT

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 — Tue, 05 Jun 2012 06:07:01 GMT

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.