Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.