Dynamic email recipient from variable

[qlikhalmar]

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!

[Lech_Miszkiewicz · Accepted solution]

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