Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
saumyashah90
Valued Contributor

Add Disclaimer while exporting to excel

When someone clicks on an export to excel an disclaimer should come.

is it possible?

Tags (1)
5 Replies

Re: Add Disclaimer while exporting to excel

Maybe with a macro it could be possible, but then you have to export with a button ....

hope it helps

Re: Add Disclaimer while exporting to excel

Hi,

You have to use Macros for this and with any text object to pass the disclaimer and put into the macro code.

Regards

Anand

saumyashah90
Valued Contributor

Re: Add Disclaimer while exporting to excel

okay i think macro wont work in Ajax client

so atleast if you guyz have any idea

like when we click on XL -> it exports table to excel

something would be happening at the backend ,somewhere from where i can know like some action took place?

saumyashah90
Valued Contributor

Re: Add Disclaimer while exporting to excel

okay i think macro wont work in Ajax client

so atleast if you guyz have any idea

like when we click on XL -> it exports table to excel

something would be happening at the backend ,somewhere from where i can know like some action took place?

Re: Add Disclaimer while exporting to excel

Object like tables or graph do not listen any action so it is not possible to trigger an event as you desire.

You're right with Ajax but it is not a general rule becouse some macros works,

here it is the one to export data (not a disclaimer)

SUB EXPORT_Percentage
set sObject1 = ActiveDocument.GetSheetObject("CH_EXPORT")
set v = ActiveDocument.GetVariable("vOggi")

sObject1.ExportBiff "E:\qlik\Accounting\Excel\" & v.GetContent.String & "_Daily_Summary_Export.xls"
end sub