Loading data 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]

Table:

CrossTable(User,Value,2)

LOAD *

FROM

test.xlsx

(ooxml, embedded labels, table is Source, filters(

Transpose()

));

rename field F1 to Year;

rename field user to Month;

See attached qvw

[Anonymous]

Hi,

Many thanks.

It worked well with transposing data.

However if we have two fields in first two columns. Please find an example in attached file.

And please help on this example too..