topic Re: Email alert based on field in QlikView

Email alert based on field

inescastelhano — Tue, 17 Jan 2017 14:52:11 GMT

Hi all,

I want to create an alert based on a condition, where the recipients should be a field.

Example:

Event owner status

1 ines.castelhano@mail.com approved

2 mary.jane@mail.com not approved

My condition would be 'if event not approved, send email to owner's email'.

However, when hardcoding the email the alert works, when using the field 'owner' as recipient, doesn't work.

Does anybody have an idea on how to solve this?

Thanks in advance.

Regards,

Ines

Re: Email alert based on field

danielact — Tue, 17 Jan 2017 16:11:58 GMT

I believe the email doesn't cycle through fields. You can try setting up a variable which concatenates the email addresses in the format used for multiple emails (I don't use alerts much, so I don't remember offhand how to separate them).

Re: Email alert based on field

krishnacbe — Tue, 17 Jan 2017 16:29:35 GMT

Hope the Owner field has multiple values.

You need to convert them into ; separated values. May be like below.

replace(GetFieldSelections(Owner), ',',';')

Re: Email alert based on field

inescastelhano — Mon, 30 Jan 2017 12:36:09 GMT

It worked perfectly with a cycle and a variable, concatenating the emails in the variables' value.

Thanks!

Ines