topic Re: Extracting multiple headers from Crosstable in QlikView

Extracting multiple headers from Crosstable

Anonymous — Thu, 31 Oct 2013 07:00:55 GMT

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.

Re: Extracting multiple headers from Crosstable

Gysbert_Wassenaar — Thu, 31 Oct 2013 09:59:08 GMT

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

Re: Extracting multiple headers from Crosstable

Anonymous — Fri, 08 Nov 2013 05:06:30 GMT

Hi,

Many thanks.

It worked well.

Re: Extracting multiple headers from Crosstable

Fri, 21 Nov 2014 20:40:18 GMT

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

Re: Re: Extracting multiple headers from Crosstable

MarcoWedel — Fri, 21 Nov 2014 22:59:23 GMT

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

Re: Extracting multiple headers from Crosstable

Fri, 21 Nov 2014 23:46:58 GMT

Thanks Marco

Re: Extracting multiple headers from Crosstable

MarcoWedel — Sat, 22 Nov 2014 00:22:17 GMT

You're welcome

regards

Marco