How to load this data in QlikView

sona_sa — Tue, 10 Aug 2021 12:48:50 GMT

Hi,

I am trying to load attached xls. But in Data dimension amount is not coming properly. Some date fields are coming. I am using below script -

AOC_Cost:
CrossTable(MonthYear, Data, 4)
LOAD Division,
Functions,
[Functions 1],
Category,
[43922],
[43952],
[43983],
[44013],
[44044],
[44075],
[44105],
[44136],
[44166],
[44197],
[44228],
[44256]
FROM [..\SAMPLE DATA.xlsx] (ooxml, embedded labels, table is Sheet1);

AOC_Cost:
Load *,Date(num#(MonthYear,'#####'),'MMM-YY') as MonthNew
Resident AOC_Cost ;
Drop table AOC_Cost;
Exit Script;

Can anyone suggest, what need to do for the same.

Thanks.

Re: How to load this data in QlikView

stevejoyce — Tue, 10 Aug 2021 13:27:35 GMT

How about using num(Data) for a new field and drop original...

AOC_Cost:
Load *
,Date(num#(MonthYear,'#####'),'MMM-YY') as MonthNew
,num(Data) as DataNew
Resident AOC_Cost ;
Drop table AOC_Cost;

drop field Data;

topic How to load this data in QlikView in QlikView

How to load this data in QlikView

Re: How to load this data in QlikView