Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
krish2459
Contributor III
Contributor III

Excel pivot data into qlikview

Hi,

We need to load excel pivot table data .

We need to transpose the data  as below.

 

Capture.PNG

Please let me know how to do that.

 

Attached is the sample data.

 

Thanks..

Labels (1)
1 Solution

Accepted Solutions
stigchel
Partner
Partner

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

2 Replies
sergio0592
Specialist III
Specialist III

Hi,

Take a look to CrossTable script function.

stigchel
Partner
Partner

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