pivot table issue

[#1]

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

[saimahasan]

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.

[marcus_sommer]

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

[Anil_Babu_Samineni]

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.

[#5]

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

this options

[#6]

thank you saima

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

[marcus_sommer · Accepted solution]

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

[#8]

hi  marcus_sommer

thank you so much your helping so much