topic Re: Copy full table Pivot into Excel in QlikView

Copy full table Pivot into Excel

Tue, 12 Feb 2013 14:39:54 GMT

We have new computers and our users are using newer versions of Windows and Internet Explorer. Still same QlikView version though.

Now, when we chose "Copy Full Table" on pivot tables and then manually paste the text in to Excel the text is still in "Pivot format" On our old system each row got a value. Is this possible to get again?

Thanks.

Re: Copy full table Pivot into Excel

Tue, 12 Feb 2013 14:56:01 GMT

In the Presentation tab select always fully expanded and then copy full table.. I think i will work..

Re: Copy full table Pivot into Excel

Tue, 12 Feb 2013 14:58:20 GMT

But our users dont have access to the Presentation tab. And we want to keep the table as a Pivot.

Re: Copy full table Pivot into Excel

Tue, 12 Feb 2013 15:08:45 GMT

pls write following macro.

set obj = ActiveDocument.GetSheetObject("CH703")
obj.ExportEx "E:\Qlikview\Department_Loadinng.xls",5

Re: Copy full table Pivot into Excel

Tue, 12 Feb 2013 15:16:15 GMT

Is this to only one Object? We want it to be applied to all tables, and only when the user want to copy the text. I mean, not automatically

Re: Copy full table Pivot into Excel

Tue, 12 Feb 2013 15:17:35 GMT

i dont think there is such property. You have to use macro..

Re: Copy full table Pivot into Excel

Tue, 12 Feb 2013 15:18:58 GMT

Ok, thanks anyway of your help.

Do you know why it worked before? Maybe earlier version of IE Plugin or something?