topic Re: Condition to send email in QlikView

Condition to send email

darkshadow91223 — Mon, 15 Jan 2018 20:27:28 GMT

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

Re: Condition to send email

uacg0009 — Tue, 16 Jan 2018 06:06:33 GMT

Hi Uriel,

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

Thanks.

Aiolos

Re: Condition to send email

darkshadow91223 — Tue, 16 Jan 2018 15:02:11 GMT

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!.

Re: Condition to send email

uacg0009 — Wed, 17 Jan 2018 02:44:17 GMT

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

Re: Condition to send email

darkshadow91223 — Thu, 18 Jan 2018 22:20:08 GMT

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 ?

Re: Condition to send email

uacg0009 — Fri, 19 Jan 2018 03:43:56 GMT

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