Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have a table which have multiple users and regions associated to them. I want to send email alert notification to only those users whose region is not doing well.
I have gone through discussions in the communities but was not able to find scenario where mail recipients can be dynamic.
If anybody have any idea on this.
Thanks in advance.
Regards,
Neha
1) 1st map the users(Email ID) to their respective region using QlikView inline load or you can maintain the excel file.
2) Now link the User(Email) to Actual data based on region.
3) Setup the SMTP server with User account from which mail should be triggered.Go to Qlikview application->Settings-> User Preference->Mail-> Here you can set the SMTP server with user account. Test the same.
4) Once email is configured in step 3, Create the alert with condition : sum(sales)<=2000 (write your actual condition for bad sales)
5) In recipient, put below expression to trigger the mail
concat(EmailID ={"=sum(sales)<=2000"}>}EmailID,';')
http://www.qlik.com/products/qlikview/nprinting
or you can use Macro, like this?
are you want to send mail using Nprinting or Macro??
1) 1st map the users(Email ID) to their respective region using QlikView inline load or you can maintain the excel file.
2) Now link the User(Email) to Actual data based on region.
3) Setup the SMTP server with User account from which mail should be triggered.Go to Qlikview application->Settings-> User Preference->Mail-> Here you can set the SMTP server with user account. Test the same.
4) Once email is configured in step 3, Create the alert with condition : sum(sales)<=2000 (write your actual condition for bad sales)
5) In recipient, put below expression to trigger the mail
concat(EmailID ={"=sum(sales)<=2000"}>}EmailID,';')
may be this like this as well?
QV Desktop -> Tools -> Alert Wizard ->A few clicks in choose On Post Reload.
See this link https://community.qlik.com/docs/DOC-3549
Vikas
You can create variable vEmailRecipients and send the mail for multiple recipients.
HTH
Vikas
Hi Kush,
i am getting error:
Could not connect to server.
Last response: Unexpected AUTH LOGINresponse, Last Response: 504
5.7.4. Unrecognized authentication type.
could you please help on this.
Regards,
Neha
Hi All,
Hi All,
I am getting this error while sending mail from qlikview.
Regards,
Neha
Choose authentication type as never. Make sure that SMTP server IP or name is correct. Also make sure that the port between QlikView server where qlikview is installed and SMTP server is open. So that You can send the mail from QlikView server