Discussion Board for collaboration related to QlikView App Development.
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?
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
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);
You can't use the apply map. Because 1 DT have many Descrition values.