how to load excel data

anat — Wed, 25 Nov 2020 16:16:04 GMT

Team,

how to load attached excel data in qlikview?

description are same for some entries ,suppose if i select asd for jan month total displaying 2,

Re: how to load excel data

MK_QSL — Sat, 30 Apr 2016 08:58:53 GMT

Something like this...

Data:

CrossTable(Month, Data)

LOAD F1,

[42005.000000],

[42036.000000],

[42064.000000]

FROM

test123.xlsx

(ooxml, embedded labels, table is Sheet2, filters(

Remove(Row, RowCnd(CellValue, 1, StrCnd(contain, 'Revenue')))

));

Final:

Load F1 as Name, Date(SubField(Month,'.',1),'MMM-YY') as MonthYear, Num(Data) as Data Resident Data

Where Len(Trim(Data)) <> 0;

Drop Table Data;