Condition to send email

[darkshadow91223]

Hi!, i have this chart:

    and depending on certain region and certain data type, will change the mail recipients like this:

          "if region= Latin america and Data type upside and difference % > 50 then send mail to someone1@example.com"

          "if region= CEEMA and Data type UpsideBook or ship and difference % > 25 then send mail to someone1@example.com"

This are my regions and data types:

    

PD: the mail recipients must be separated by , or can be separated with enter?

example1@example1.com, example2@example2.com, example3@example3.com, OR

example1@example1.com

example2@example2.com

example3@example3.com

[uacg0009]

Hi Uriel,

So can I know where you want to use the user list? NPrinting or somewhere else?

Thanks.

Aiolos

[darkshadow91223]

Hi Aiolos,

     i couldnt understand you, i only want to use the user list, depending in the Region and Data Type and percentage difference will be the user.

Could you explain more about Nprinting?

Thanks!.

[uacg0009]

Hi Uriel,

NPrinting is just an another tool of QlikTech.

I just want to know how do you send email if you have the user list..

Thanks.

Aiolos

[darkshadow91223]

Hi Aiolos,

     rigth now i am not sending emails because im trying to get de condicion to do it, in the main table i need to send those lines that 'Difference %' more than 20% OR 'Difference $' more than 50Million but i dont know how to put it in a expression, how can i pull data from the chart to compare it ?

[uacg0009]

Hi Uriel,

I think it's better to give a sample and the result you want or tell me the definition of difference % and difference $.

For now, maybe you need to try to use below expression in the text object:

=concat(distinct aggr(nodistinct if("your differencce % expression" > 0.2 or "your difference $ expression" > 500000,

     "the corresponding email"),Region,Country,[Sub Region1],[Sub Region2],[Data Type]),',')

Thanks.

Aiolos