Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anat
Specialist II
Specialist II

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
MK_QSL
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;