I need to send an email to managers when they have contracts due. I figured out how to trigger an email if the Sum of a column > than a given number but can't figure out how to check each record on the date field. I would like to set it up so upon each reload, if the 'Renew Contract Date' field equals that day, it will trigger an email to that person. On 1/1/2018 one email would go out to Joe. On 2/2/2018 one email would go to Sally and one to Bob and on 4/4 and email would go to Joe, Doug and diane. See table below.
Thank you for the example. I could not get it to work. I started slowly simplifying first by giving it one email recipient instead of having to derive by expression. I then tried to simplify the Condition. I cannot get it to work line by line. I am only able to get it to work with a calculation of all records. When I summed the Contract number I was able to get it to send and email.
It does not seem to be looking at each record and acting one by one.
I simplified the expressions until I got it to work . See attached. If I just have one record then it will work if the day is correct. As soon as I add other records it fails. How do I make it iterate through the records?
Not able to get this to work. It tries to send it but I get this error-
"Could not connect to Server.
Last Response: Unexpected RCPT TO response, Last Response:
501 5.1.3 Invalid address"
I know the email is correct because if I use simply =[Email] It will work.
I have a some questions on your expression: =if([UserID]=QVUser() and Noofdays=0 ,Concat(Email,';'))
1. In your example you used [User ID] with a space. Was this a typo or did you mean it to have a space?
2. QVUser - I don't think QVUser is involved unless section access is being used. I am not using section access.
3. I don't understand the need to compare UserID to QVUser?
4. Concat - This is the first time I have used 'Concat' so I am confused on how it is being used here. Is it meant to create a semicolon delimited list of email addresses so one email goes out to multiple people?
5. Can QlikView Alerts send multiple distinct/separate emails out? For example If Bill's contract is due it will send him an email with the contract number and other details specific to him. Then when QlikView looks at the second record it sees that Joe's contract is also due and sends him his own distinct email?
It seems that everything breaks as soon as I add a second record to the inline load as it does not know what to do with more than one record.