topic Re: pivot table issue in QlikView

pivot table issue

Tue, 26 Jul 2016 04:48:25 GMT

hi all,

i have pivot table am trying to export pivot tablefrom qv to excel but that excel data showing in straight table only

how to get pivot table in excel

help me

thanks in advance

Re: pivot table issue

saimahasan — Tue, 26 Jul 2016 07:35:08 GMT

By default, Qlikview exports Pivot into Straight table format. In order to get the Pivot table into Excel, you need to copy the table by right clicking on chart ->Copy to Clipboard ->Full Table and then paste the table in Excel.

Re: pivot table issue

marcus_sommer — Tue, 26 Jul 2016 07:37:09 GMT

AFAIK it's not possible by using the export-features. But if you choose copy from the context-menu and there the option whole table then you will get the pivot-structure after pasting it into excel.

- Marcus

Re: pivot table issue

Anil_Babu_Samineni — Tue, 26 Jul 2016 07:57:51 GMT

I agree Marcus content.

Because, That macro will export only data not for actions. Still you want to show that you need to create same thing in Excel.

Re: pivot table issue

Tue, 26 Jul 2016 11:44:41 GMT

in developer version it s working but after deploying the qvw that option not showing Copy to Clipboard ->Full Table

this options

Re: pivot table issue

Tue, 26 Jul 2016 11:45:58 GMT

thank you saima

but in server version not showing what to do please help me

Re: pivot table issue

marcus_sommer — Tue, 26 Jul 2016 12:22:58 GMT

Within the access point you could choose print which opened your table within a new tab and from there you could simply copy + paste the table into excel.

- Marcus

Re: pivot table issue

Wed, 27 Jul 2016 03:42:33 GMT

hi marcus_sommer

thank you so much your helping so much