Extracting multiple headers from Crosstable

[Anonymous]

Hi,

I need to load data from an excel and the data is in cross table.

Please find the details in the attached excel sheet.

There are two tabs in excel sheet.

I have given sample data in source tab.

In QlikView need to create List boxes based on heading mentioned in source tab.

Details have shown in Requirement tab.

Please help on this example.

[Gysbert_Wassenaar · Accepted solution]

See attached example. If a user can be part of only one team use the script on the first tab instead.

[Anonymous]

Hi,

Many thanks.

It worked well.

[#4]

Hello Gysbert, or anyone with a full Qlikview License,

Can you post the code from your qvw on here? As I only have personal addition I cant open your file. It will solve my problem.

Kind regards

Connor

[MarcoWedel]

T3:
LOAD if(len(trim(A))<>0, A & '|'  & B) as AB,
    C,
    D,
    E,
    F,
    G,
    H,
    I,
    J,
    K
FROM

(ooxml, no labels, table is Source);

store T3 into T3.qvd;

T4:
CrossTable(TeamUser,Value,2)
LOAD * FROM

(qvd, embedded labels, filters(
Transpose()
));

T5:
load
  F1 as Year,
  [Team|user] as Month,
  subfield(TeamUser,'|',1) as Team,
  subfield(TeamUser,'|',-1) as User,
  Value
Resident T4;

drop table T3, T4;

hope this helps

regards

Marco

[#6]

Thanks Marco

[MarcoWedel]

You're welcome

regards

Marco