topic Please find the attachment in QlikView

Please find the attachment

Fri, 12 Dec 2014 03:40:25 GMT

FYI...

Re: Please find the attachment

jagan — Fri, 12 Dec 2014 03:58:17 GMT

Hi,

Check this script

Data:

LOAD Company,

Department_CUTTING,

Factory_CUTTING,

Owner_CUTTING,

DATE,

[Plan 2day ready to issue stock_CUTTING],

[Actual 2day ready to issue stock_CUTTING],

[Plan BPCD hit rate_CUTTING],

[Actual BPCD hit rate_CUTTING],

[Plan SPCD hit rate_CUTTING],

[Actual SPCD hit rate_CUTTING],

[Plan FPY_CUTTING],

[Actual FPY_CUTTING],

[Plan Cutting Overall Efficiency_CUTTING],

[Actual Cutting Overall Efficiency_CUTTING],

[Plan Cutplan vs Acheivement_CUTTING],

[Actual Cutplan vs Acheivement_CUTTING],

[Plan OTD_CUTTING],

[Actual OTD_CUTTING],

[Plan Cut sending plan vs Acheivement_CUTTING],

[Actual Cut sending plan vs Acheivement_CUTTING]

FROM

[CUTTING.qvd]

(qvd);

Temp:

LOAD

Max(DATE) AS MaxDate

RESIDENT Data;

LET vMaxDate = Date(Peek('MaxDate'));

DROP TABLE Temp;

Concatenate(Data)

LOAD Company,

Department,

Factory,

Owner,

Date(Month) as DATE,

Accounts,

[Plan PSD],

[Actual PSD],

[Plan Bulk PCD],

[Actual Bulk PCD],

[Plan Sizeset PCD],

[Actual Sizeset PCD],

[Plan Ordership],

[Actual Ordership],

[Plan Lost time],

[Actual Lost time]

FROM

[FM.xls]

(biff, embedded labels, table is FM$)

WHERE Date(Month) > '$(vMaxDate)';

Regards,

Jagan.