Excel pivot data into qlikview

[krish2459]

Hi,

We need to load excel pivot table data .

We need to transpose the data  as below.

Please let me know how to do that.

Attached is the sample data.

Thanks..

[sergio0592]

Hi,

Take a look to CrossTable script function.

[stigchel · Accepted solution]

Something like this

CrossTable(Date, Value,5) LOAD *
FROM
[C:\STIGCHEL\New Microsoft Excel Worksheet.xlsx]
(ooxml, embedded labels, table is Tabelle1, filters(
Remove(Row, Pos(Top, 4)),
Remove(Row, Pos(Top, 3)),
Remove(Row, Pos(Top, 1))
));