Macro with condition

[ajaykumar1]

Hi Everyone,

I have the data like below. Need to send E-mail to users by macro only when all countries have value  > 1 then ABC users

Note : If In case any country have value less than 1 then need to send the mail to Development teams

In below Case Mail should go to Development team because US,UK and Malaysia have less than 1.

Country      Value

India             890

US                 009

UK                 1

PAK               7809

Malaysia           0

In below Case Mail should go to ABC users because all countries have value more than 1.

Country      Value

India             890

US                 9

UK                 100

PAK               7809

Malaysia       3000

More Thanks,

Ajay

[Oleg_Troyansky]

I'm not sure what is your question here... Anyway, it sounds like you could use QlikView Alerts functionality to avoid writing macros.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

[ajaykumar1]

Any reply from anyone?

More thanks,

Ajay

[Oleg_Troyansky]

Hi Ajay,

yes, I replied to your question and I gave you a direction that you can follow to get the desired results. If you just expect someone to write the macro for you, I doubt if this is the right forum for that. That is called consulting.