topic Re: Macro with condition in QlikView

Macro with condition

ajaykumar1 — Wed, 14 Oct 2015 18:28:53 GMT

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

Re: Macro with condition

Oleg_Troyansky — Wed, 14 Oct 2015 20:22:09 GMT

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

Re: Macro with condition

ajaykumar1 — Thu, 15 Oct 2015 08:12:45 GMT

Any reply from anyone?

More thanks,

Ajay

Re: Macro with condition

Oleg_Troyansky — Thu, 15 Oct 2015 13:59:48 GMT

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.