topic Send mails to particular users based on condition. in QlikView

Send mails to particular users based on condition.

dhanu_today — Fri, 10 Apr 2015 07:08:24 GMT

Hi everyone,

Currently am scheduled my batch file through windows scheduler and mails are delivering to users finely.

But i need to send mails to users when the Data is updated then only else to our development team.

Scenario : I have the fields like Date , Country. Am sending mails to users related to the country data 'France'.

Daily around 11.00 am i scheduled my task and its working fine mostly. But when the data is not available for the 'France' then also its going to users with blank data'. I want to avoid this case.

I tried like this :

This is the variable varTO logic and the VarTO is used in the macro.

If(match(Country,'France') and Date=Date(today())),'mailidsofallusers','development team mailids');

I tried the above logic in the chart but its working fine But when i run the schedular its always giving second result 'development team mailids'.

Need help how to avoid this case.

More Thanks,

Dhanu

Re: Send mails to particular users based on condition.

dhanu_today — Fri, 10 Apr 2015 09:09:01 GMT

Hi all,

Any help Hints anyone?

Thanks,

Dhanu

Re: Send mails to particular users based on condition.

pokassov — Fri, 10 Apr 2015 09:42:26 GMT

Hi!

Can you atach your expamle?

Re: Send mails to particular users based on condition.

ajaykumar1 — Fri, 23 Oct 2015 05:27:07 GMT

Any help from someone.Unable to attach the application.

Thanks,

Dhanu

Re: Send mails to particular users based on condition.

jonathandienst — Fri, 23 Oct 2015 05:42:59 GMT

The expression works in your chart because the chart dimensions limit the possible values of Country and Date to a single value each.

I am not sure exactly how you are using the expression/variable in a macro, but in that context, Country and/or Date can take on multiple values and the use of the naked* field names will return null -- so the if() will always evaluate to false.

If you post your qvw file, or a representative sample, someone may be able to give you specific help on how to correct this issue.

* This means the use of a field name outside an aggregation function like Sum(), Min(), Count(),....