how to load excel data

[anat]

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,

[MK_QSL]

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;