Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

nnellore
New Contributor II

Extracting multiple headers from Crosstable

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.

1 Solution

Accepted Solutions

Re: Extracting multiple headers from Crosstable

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


talk is cheap, supply exceeds demand
6 Replies

Re: Extracting multiple headers from Crosstable

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


talk is cheap, supply exceeds demand
nnellore
New Contributor II

Re: Extracting multiple headers from Crosstable

Hi,

Many thanks.

It worked well.

Not applicable

Re: Extracting multiple headers from Crosstable

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

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

Not applicable

Re: Extracting multiple headers from Crosstable

Thanks Marco

Re: Extracting multiple headers from Crosstable

You're welcome

regards

Marco

Community Browser