topic Importing excel pivot table data in QlikView

Importing excel pivot table data

Fri, 16 Apr 2010 10:42:37 GMT

I am trying to import data from excel. The data is only available in a pivot table (Countries in lines, years in columns). Is there an easy way to bring this into Qlikview or should I write macro in Excel to sort it out first?

Importing excel pivot table data

prabhu0505 — Fri, 16 Apr 2010 11:04:02 GMT

Hi Dewald,

This is not an anwser but a hint, try 'Enable transformation' tab in the File Wizard.

Importing excel pivot table data

Fri, 16 Apr 2010 11:28:43 GMT

Thanks, tried that but doesn't seem to work

Importing excel pivot table data

Fri, 16 Apr 2010 16:38:17 GMT

Hello,

check out the "Crosstable" prefix of a load statement.

Also the file wizard provides the crosstable option ... it is on the 3rd page of the dialog, AFTER the transformation page (See Crosstable Button).

hth,
Thilo