topic Re: Loading data from crosstable in QlikView

Loading data from crosstable

Anonymous — Wed, 30 Oct 2013 13:53:28 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.

Gysbert_Wassenaar — Wed, 30 Oct 2013 14:09:21 GMT

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 — Wed, 30 Oct 2013 14:30:48 GMT

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..