topic Re: Generate excel file from the load script in QlikView

Generate excel file from the load script

Wed, 11 Dec 2013 09:40:06 GMT

Hi everybody,

I'm Maurizio, I'm a new user of Qlikview and this is my first open thread!

I have this macro
Sub ExportExcel

Set tableToExport = ActiveDocument.GetSheetObject("CH04")

tableToExport.Export "C:\output.csv",";"
End Sub

I can call this sub pressing a button but how can I run it from the load script?

Maurizio

bbi_mba_76 — Wed, 11 Dec 2013 09:45:41 GMT

Hi,

I think it is not possible from the script (this is a sub using visualisation objects)

You could use the onPostReload trigger (settings-document-triggers) and add the same action you set in the button.

Wed, 11 Dec 2013 09:56:41 GMT

Thanks a lot!

That's just what I need!

Wed, 11 Dec 2013 11:15:23 GMT

I got another issue related to the task.

If I run the load script manually It works, but If I run the load script by using Qlikview Server no files are created. How could I resolve?

Maurizio

bbi_mba_76 — Wed, 11 Dec 2013 11:20:49 GMT

Well, the reload with the distribution service does not load the visualisation object, so your chart is not created during the reload.

You have to use the qv.exe to run the reload (by batch) or you could create a similar table in your script and the store it.

Wed, 11 Dec 2013 13:01:50 GMT

Got It! Thanks again!

Maurizio