Dynamic email recipient from variable

qlikhalmar — Sun, 07 Feb 2021 19:51:30 GMT

Hi All,

I am struggling with a new feature. I have a QVW with 3 ID's. Every ID has a number of rows. I made a Pixel perfect report and want to use a cycle to generate 3 reports.

In my QVD is a field email address. For every ID a different address. I have made two variables: vEmail (MAXSTRING(EmailField)) and vEmailNP (=$(vEmail)). The variable vEmailNP have i added to the recipient field in my email message. I also added a normal user.

I expect that every report was send to a different email address during the cycle. But it didn't work.

Can anyone help me with this one?

Thanks!

Re: Dynamic email recipient from variable

Lech_Miszkiewicz — Sun, 07 Feb 2021 22:04:56 GMT

Hi - this is not how this feature works.

Your variable will be evaluated against the set of filters for the user/recipient. It will not evaluate against each cycle value. So, your assumption is wrong and it will not work.

If your goal is to link each individual ID with individual emails you should link this via individual recipients.

regards

Lech

topic Re: Dynamic email recipient from variable in Qlik NPrinting

Dynamic email recipient from variable

Re: Dynamic email recipient from variable