topic Re: Sending Qlikview table data as E-Mail in QlikView

Sending Qlikview table data as E-Mail

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

Hello,

I have following requirement to send qlikview table data as email,

1. Table data need to be dumped into excel sheet (old file deleted for every execution)

2. Dumped excel sheet data need to send as email, Here when there is no data in excel means then it should not attach excel sheet, Instead it should send a mail with comment as " No data available"

Please note i have tried with attached VB Script, which works fine when it has Data, But when it has no data, It's not working.

Please do revert with macro's for to achieve it, Also correct me if anything wrong in script.

Best Regards,

Re: Sending Qlikview table data as E-Mail

vikasmahajan — Wed, 17 Oct 2018 06:55:28 GMT

check this link https://community.qlik.com/thread/74788

Vikas

Re: Sending Qlikview table data as E-Mail

andrei_delta — Wed, 17 Oct 2018 06:59:22 GMT

hi,

maybe this will help?

Creating a Report and Using PDF Distribution - YouTube

Re: Sending Qlikview table data as E-Mail

MindaugasBacius — Wed, 17 Oct 2018 07:13:22 GMT

I usually do a minor trick in Macros:

SET obj = ActiveDocument.GetSheetObject("info")

control = obj.GetRowCount

IF control > 1 THEN

send_report vTO, vCC, reportFile, vName

END IF

It do not trigger the send_report function if the Table called info do not have any data.

Still to send a mail with text "No data available" I suggest you trying the Alerts functionality.

Re: Sending Qlikview table data as E-Mail

muthukumarbalu — Thu, 18 Oct 2018 06:00:16 GMT

This works well, Thanks mindaugasbacius