topic Re: PostReload trigger exporting chart to xls does not work in QlikView

PostReload trigger exporting chart to xls does not work

jimmygohhanjie — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

Thanks for your attention.

I have setup the below marco to run on Post reload. however it does not work. (screenshot of security at the bottom).

The marco works fine when i click TEST on the Edit Module dialog.

However it does not work when i reload my data.

This is running on my local machine, not server.

Thanks for your time, and appreciate your assistance on this.

User setting security

Document Security.

olivierrobin — Tue, 27 Mar 2018 14:24:43 GMT

hello

what do you mean by doesn't work

error messages ? if so which ones ?

jimmygohhanjie — Mon, 02 Apr 2018 02:22:36 GMT

Hi,

Apologies for the delayed reply, was away from work.

There is no error msg and the expected excel was not generated. from my Qvw.

I have tried the above solution. The Solution QVW does generated the excel.

I have model it the same. however my QVW does NOT generate the excel.

i am guessing it is the DOCUMENTING setting. wondering which checkbox need to be tick or untick.

I cant share my QVW as it contain sensitive data.

tamilarasu — Mon, 02 Apr 2018 04:08:54 GMT

Hi Jimmy,

Why do you have such a long space in your file path?

Jimmy Goh wrote:

The marco works fine when i click TEST on the Edit Module dialog.

However it does not work when i reload my data.

Are you sure? Did you see the file get exported to the specified folder?

jimmygohhanjie — Wed, 04 Apr 2018 01:50:11 GMT

Thanks for spotting..

i will need to recreate and try again.

As advised by my IT, our server does not have excel. this function will be removed.

However, i will still try to make sure my local will work.

Thanks for your time and sharp eye.