topic import pivot from excel in QlikView

import pivot from excel

Thu, 12 Jul 2012 11:45:26 GMT

Hi all, i'd like to ask you

can qlikview import pivot from excel, if it possible, could anyone explain how?

Thanks

Re: import pivot from excel

Thu, 12 Jul 2012 12:04:48 GMT

what do you mean : "import pivot table"

all the data despite the selection, dimension etc? or just the data that you see?

Re: import pivot from excel

Gabriel — Thu, 12 Jul 2012 12:14:32 GMT

Hi Navarone,

What you have to do is open new qlik file - use ctlr + E (edit script or from File menu click Edit Script) - click Table Files - browse to the excel file you want to import. Click save button and then Reload. You should have your file imported into QlikView.

You can also use the import Wizard for this. Let me know if this is helpful.

Regards,

Gabriel

Re: import pivot from excel

Fri, 13 Jul 2012 03:47:44 GMT

what i mean is,

can qlikview load the data from a pivot in excel ?

Re: import pivot from excel

Gabriel — Fri, 13 Jul 2012 21:18:48 GMT

Hi,

I know this might be possible using scripting. If you want to import Pivot from excel, in my limited knowledge of QlikView, is best to pitvot the data out and copy and paste the data (turn to static) then import the table to QlikView.

Message was edited by: gabsus04