Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I want to make a trigger every night at 00:00 automatically reload the whole document and export to html format.
But it isn't working. How can I do? What must I do on qlikview management console?
sub ExportAsHTML
ActiveDocument.GetSheetObject( "CH01" ).ExportHtml "C:\Users\aidata\test.htm"
end sub
Thanks...
Your issue is that you are trying to run a macro on QVS. Macros can only be run on clients, not on the server. So if you need this macro to be called, you need to do the following:
That should do the trick.
Hi ,
I am getting the error as "Error in writing " when i am trying to export the chart as the HTML page through macro. How ever if i am trying to export the table or the list box as the html Page it is working fine. Is the functionality ExportHTML is applicable only to the Table and list box. And not applicable to the Charts. Please correct me if i am wrong.
Is there any way to execute that macro withought owning QV publisher???
My company only has the qlikview server installed.
Hi XXX
Have you tried the macro ServerSideExport? Or ServerSideExportEx.
Kavrosda:
If you install a developer on the server you can use Windows Task scheduler to run qv.exe as a batch job.
syntax : qv.exe /r <appname.qvw>
This will trigger the macro.