inporting pivot table from excel to qlikview

[stevietm]

Hi All

I have some data on Excel in table format how can I send that to Qlikview.?

Regards....

[#2]

Go to the script section [cntl-e]

Press the table files button at the bottom

Browse to your file name, Press Open

Press Finish

Press Reload (Save your QV doc if you haven't saved it yet too)

Press Add All

Press OK

Arrange the objects and start having fun

[stevietm]

Shweet thanx for the help...

[prieper]

The above method works to load the Excel-sheet 1:1, if you like to normalize a pivot-table, you may use the CROSSTABLE-functionality.

HTH
Peter