topic Automatic Reload QVW on daily basis (google Spreadsheet connector) in QlikView

Automatic Reload QVW on daily basis (google Spreadsheet connector)

Wed, 11 Jan 2017 12:41:10 GMT

Hi,

we have a qvw file where we loaded data using the qlik connector- Google drive and spreadsheet connector

I have a requirement to sent the email alerts daily based on the reload,so for this i need to create automatic reloads on daily basis (normally it was achieved by using .bat file )

will the bat file works in this scenario,if works please let me know the steps

and i have qlikview server and publisher

Thanks in advance

Re: Automatic Reload QVW on daily basis (google Spreadsheet connector)

krishnacbe — Wed, 11 Jan 2017 17:33:51 GMT

Hi,

Hope below suggestion helps.

1. Create a Alert using Tools -> Alert Wizard

2. In step 3 select the "On Post Reload" option

3. Define your Custom Message and recipients

3. If you have publisher, create a task to reload the dashboard and schedule it with daily refresh.

4. Through publisher, if the task reload the QVW, on post reload the email will be sent

Re: Automatic Reload QVW on daily basis (google Spreadsheet connector)

sanketkhunte — Wed, 11 Jan 2017 17:42:59 GMT

Thanks Krishnapriya.

Can you please share sample application, if possible.

Re: Automatic Reload QVW on daily basis (google Spreadsheet connector)

krishnacbe — Wed, 11 Jan 2017 18:00:48 GMT

Hi Sanket,

I should not upload any documents from my client machine.

Hope the Steps mentioned are clear. If you found any issue let me know.