topic Re: Send Mail/Alert to users in QlikView

Send Mail/Alert to users

Tue, 12 Aug 2014 13:05:04 GMT

Hello Everybody,

I am trying to send an email alert on the refresh of the dashboard to the users who have not filled their time sheet .

I found couple of posts in this community on how to make email alert/send mail.

I want to know how I will proceed with that means what Condition I will put in the Alert Tab-> condition

and do I have to write all the user's mail id(those who have not filled their Time sheet) under the mail recipients or I have to create any variable for that?

Please help..

Thanks in Advance
Sonali

Message was edited by: Sonali Singh

Re: Send Mail/Alert to users

Wed, 13 Aug 2014 12:36:39 GMT

Please Help

Re: Send Mail/Alert to users

ashfaq_haseeb — Wed, 13 Aug 2014 12:41:41 GMT

Hi,

Have a look at attached application.

Regards

ASHFAQ

Re: Send Mail/Alert to users

Wed, 13 Aug 2014 14:12:38 GMT

Hi Ashfaq,

Thanks for your reply.

I understood the functionality of Alert Tab but my requirement is user should get one mail alert those who have not filled time sheet.

I don't want to hard coded the recipients it should go automatically those who have not filled time sheet. Like you have created "EmailAlertTo" table, What I have to create?

And in the expression tab of Alert Wizard what Expression should I put so that if the condition will true then it will send alert.

I have attached my sample QVW.

Please have a look and Do Reply.

Many Thanks

Re: Send Mail/Alert to users

sudeepkm — Wed, 13 Aug 2014 14:26:26 GMT

create a table in your data model which will have the UsersEmail and TimeSheetFilledStatus.

in the Alert Email Recipients you can use something like below.

concat({<TimesheetFilledStatus={'NO'}>} UsersEmail,';')

The above expression will create a string capturing all those Users Emails where the users have not filled the time sheet.