I have one requirement where in a dashboard, for an filter condition I need to send email of one table box object result as a spreadsheet to the user. This has to be a scheduled activity. Could someone throw some light on this? What I could think about is Alerts and Macros.
If your Server has Publisher license, you can create a new task and send an email when finished. But you can also use the code in this thread among many others to create a macro to send emails. You will need to add the attachment part to the macro with your file.
You can create a new macro to export the chart to a xls or csv file and use it as the attachment.
There are several things here. The macro will not trigger when the document is in the Server. What I would do is to create a trigger OnOpen or OnPostReload (Settings menu, Document Properties, Triggers, OnOpen, Add new action, External, Run Macro) and create a Windows Scheduler task to lauch a .BAT file similar to the following:
You just answered what I had next in my mind. The reload wont fire the macro for me on the publisher thats correct. Currently we do have a different way we do that, we have the alert created that would get triggered during the reload. This would send a mail. Not sure if there is a way to send a attachment through the alert.
Glad to help. Unfortunately, there is no way to attach files to alerts so far, if you need to send the file in all cases, you will need to create a macro and use the Windows Scheduler or something, but not with QlikView.
EDIT: Well, you already have Publisher, that means that if you have the PDF license you can send by email a report with that object in PDF, or even a reduced QlikView document with only that object, which means that every recipient will need QlikView Desktop in their computers. Does that suit you?