Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

how to load excel data

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,

1 Reply
Highlighted
MVP
MVP

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;