Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
muthukumarbalu
Contributor III
Contributor III

Sending Qlikview table data as E-Mail

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,

MB

1 Solution

Accepted Solutions
MindaugasBacius
Partner
Partner

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.

View solution in original post

4 Replies
vikasmahajan

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

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
andrei_delta
Partner
Partner

MindaugasBacius
Partner
Partner

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.

muthukumarbalu
Contributor III
Contributor III
Author

This works well, Thanks mindaugasbacius