topic Excel pivot data into qlikview in QlikView

Excel pivot data into qlikview

krish2459 — Sat, 16 Nov 2024 20:29:41 GMT

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

Re: Excel pivot data into qlikview

sergio0592 — Tue, 09 Jul 2019 13:08:39 GMT

Hi,

Take a look to CrossTable script function.

Re: Excel pivot data into qlikview

stigchel — Tue, 09 Jul 2019 13:22:09 GMT

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))
));