Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do i load these excel files

I need a good model to load these 3 sheets in attached excel so I can see the relationship between these 3 tables. I wanna drill down from Description >> Class in Dimension and have Gross, Net and Cost in expression what do I do?

13 Replies
Not applicable
Author

S/N cant be our unique identifier. In this case please.There is no [S/N] in the database we just used it to show the numbering

sathishkumar_go
Partner - Specialist
Partner - Specialist

OK.. that is the case ClassNo is the key field

Class:
LOAD
// [S/N] as KEY,
  [S/N],
CLASS,
[Class no],
[Class no] as KEY,
GROSS,
NET
FROM

(
ooxml, embedded labels, table is Classes);

HostelInfo:
LOAD
// [S/N] as KEY,
  [S/N] AS SN_HostelInfo,
HOSTEL,
Descrition,
[DT number],
Cost
FROM

(
ooxml, embedded labels, table is [Hostel info]);

left join (HostelInfo)
LOAD [DT number],
Descrition as KEY
FROM

(
ooxml, embedded labels, table is Link);

-Sathish

sathishkumar_go
Partner - Specialist
Partner - Specialist

sathishkumar_go
Partner - Specialist
Partner - Specialist

Hi..

You can't use the apply map. Because 1 DT have many Descrition values.

-Sathish