topic Re: pivot table data export to Excel in QlikView

pivot table data export to Excel

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

While exporting pivot table data to the Excel is it possible to display the Table title on Excel also along with that i need to display note describing calculations been given.

Is their any option please help me to do

Thanks

Re: pivot table data export to Excel

bindu_apte — Wed, 08 Jun 2016 11:12:13 GMT

Hi,

Hope this thread will help.

Export to excel with chart header.

Re: pivot table data export to Excel

sujeetsingh — Wed, 08 Jun 2016 11:22:16 GMT

Go to General tab on the object (table, pivot table, etc.) settings and press "Print Settings" button. Under tab Header/Footer you can specify what you want to print.

Here you can also specify standard variables, for example &[Title] in "Center Section" to print table title as header of the page.

Try pressing "Default" button on this window and you will see what I am talking about. Hope this is what you are looking for.