topic Re: Export The Caption into excel from Straight / Pivot Table in QlikView

Export The Caption into excel from Straight / Pivot Table

Ankhi — Sat, 16 Nov 2024 17:58:56 GMT

Hi All,

I have straight tables/Pivot tables with the option of Send To Excel. However the send to excel does not include the Caption once the table is exported to the excel. I would need the Caption in the excel as well.

Can any one please help?

Regards

Ankhi

Re: Export The Caption into excel from Straight / Pivot Table

Chanty4u — Tue, 13 Oct 2020 12:31:53 GMT

i think there is no direct option to get this . you need to use macro . below there is solution provided please have a look

https://community.qlik.com/t5/QlikView-App-Development/How-can-I-export-title-Caption-in-Excel/m-p/1005256

Re: Export The Caption into excel from Straight / Pivot Table

Ankhi — Mon, 19 Oct 2020 09:14:04 GMT

Hi Chanty,

Thanks for the reply.

Would you be able to explain in a bit more detail please? I have gone through the above solution. What I was able to do is open my app from my desktop , do a ctrl +m to write the macro and then for the straight table I was doing it , the data got exported with the caption.

However, the same needs to happen from the Access Point. When the user will export the report from the access point, the exel should be exported with the caption. Also I am not sure whether this needs to be done on individual tables as well or not.

Hope I have clarified what I need.

Many Thanks

Regards

Ankhi

Re: Export The Caption into excel from Straight / Pivot Table

Brett_Bleess — Tue, 27 Oct 2020 16:11:23 GMT

Best I can offer is the Help Doc, which provides the following regarding User Preferences for exports. For Ajax Clients, the setting would need to be added to the QVServer Settings.ini file, and would apply to all users, they would not be able to set things individually...

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/User_Preferences_Output.htm

That being said, I am not sure any of those settings are going to do what you want here, so the macro is an option, but with Ajax all macros run server-side, so that too may become an issue as if the API call is a client-side call, it will not run correctly on the server etc.

Other options would be to consider using the Report Editor to create a report where you can place the Caption in the Report, or NPrinting may be another way to go. Here is Help link to Report Editor:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Report_Editor.htm

Regards,
Brett