13

QlikView Scheduled Reports – Sending Excel via Email part 2

In last post I showed you how we can use even Personal edition of QlikView to schedule excel file generation and sending an email with it as an attachment. It was simplistic example. One table exported to one worksheet within an excel file and sent to only one recipient. Today I want to tell you how we can add multiple objects to Excel file,  how to format its content using VBScript and finally how to send it to multiple recipients. Well.. Let’s jump into it! Continue Reading

14

QlikView Scheduled Reports – Sending Excel via Email

In company I work for higher management often requires specific data delivered to their mailbox every morning. They are not interested in interaction, using filters and “playing” with data.  They just want their predefined Excel ready when they will turn on PC.

Of course great solutions like Qlik’s new acquisition: NPrinting exist to do such things, but there is a way to do it even with Qlikview Personal Edition. Lets jump right into it! Continue Reading