topic Re: Add Disclaimer while exporting to excel in QlikView

Add Disclaimer while exporting to excel

saumyashah90 — Fri, 30 Jan 2015 07:41:04 GMT

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

is it possible?

Re: Add Disclaimer while exporting to excel

alexandros17 — Fri, 30 Jan 2015 07:47:11 GMT

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

its_anandrjs — Fri, 30 Jan 2015 07:52:48 GMT

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

Re: Add Disclaimer while exporting to excel

saumyashah90 — Fri, 30 Jan 2015 08:17:37 GMT

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

saumyashah90 — Fri, 30 Jan 2015 08:17:53 GMT

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

alexandros17 — Fri, 30 Jan 2015 08:23:14 GMT

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