Discussion Board for collaboration related to QlikView App Development.
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.
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))));
View solution in original post
Take a look to CrossTable script function.