topic Re: alert mail or alert error in QlikView

alert mail or alert error

Anonymous — Fri, 18 Oct 2013 07:26:20 GMT

Hi..

I have an doubt please clarify me..

I have an table

Country,Sales two fields.daily I am fetching data from the data base for example My table looks like this

Country,Sales

USA,800

India,700

UK,900

Germany,500

Like this I am daily fetching data I want alert mail or alert error when any these country is goes to sales less than 200..?

how I want to make changes when I need this type of task..?

Thanks in Advance.

Re: alert mail or alert error

kaushiknsolanki — Fri, 18 Oct 2013 07:34:08 GMT

Hi,

Go can go to alert wizard and there you can add the relevant information and create an alert.

For more information you can also go to Help.

Have a look at the application attached.

Regards,

Kaushik Solanki

Re: alert mail or alert error

Anonymous — Fri, 18 Oct 2013 08:03:26 GMT

Hi Kaushik,

Thanks for a REPLY,I want dynamic data you are mentioning country = India,if any other country goes to below threshold means there is no alert message.

Re: alert mail or alert error

kaushiknsolanki — Fri, 18 Oct 2013 08:07:00 GMT

Hi Sara,

That depends on the condition, you can modify the condition as you want.

I took India just to show how it works.

Regards,

Kaushik Solanki

Re: alert mail or alert error

Anonymous — Fri, 18 Oct 2013 11:43:13 GMT

But its not working properly for me could you able to give some other solution for this..!!

Thanks in Advance.

Re: Re: alert mail or alert error

Fri, 18 Oct 2013 11:49:50 GMT

Using aggr() you can achieve...

Find revised file of kaushik..

Karthik

Re: Re: alert mail or alert error

tresB — Fri, 18 Oct 2013 11:57:06 GMT

Sara,

See the attached sample.

Re: alert mail or alert error

rajni_batra — Fri, 18 Oct 2013 11:57:31 GMT

Hi Kartikeyan & Karthik,

I have learnt new thing today

If suppose i want like to pop up or mail list for those country having sales less than 200 along with data

how that can be done?

Regards,

Rajni

Re: alert mail or alert error

Fri, 18 Oct 2013 12:15:33 GMT

By using tresesco solution you can find list of countries those are less than 200..

and you have to set smtp details on Settings --> User Preference --> Mail.

In alert you have to mention mail id and subject..

Thats all..

Karthik

Re: Re: alert mail or alert error

tresB — Fri, 18 Oct 2013 12:23:29 GMT

Rajni,

PFA for what you want.

Re: alert mail or alert error

rajni_batra — Fri, 18 Oct 2013 12:45:11 GMT

Thanks tresesco

Regards,

Rajni

Re: Re: alert mail or alert error

Anonymous — Fri, 18 Oct 2013 13:27:56 GMT

Thanks Treseco,

what I want Do If I want sent this alert message to my boss Mail Id..

Karthick Told in above discussion need do some changes in the smtp.But its not working properly for me could you please help me..

Thanks in Advance ...

Re: alert mail or alert error

tresB — Fri, 18 Oct 2013 13:37:53 GMT

It is more about configuration. If you have Publisher/PDF distributor or not....

But a general info:

GMAIL has been taken for example:

     If you have Qlikview Server then you will find the settings for setting mails at

     QEMC -> Settings -> Setup -> Mail Server

     Here you have to define the Host Name as smtp.gmail.com (incase you are using gmail account.)

     Then you need to specify the mail address at From Address.

     Then you Need to use the authentication as per your requirements.

     Click Apply.

     If you dont have server then you will find the mail configuration in Qlikview.

     Open Qlikview Document

     Settings-> User Preference -> Mail

     Here in sender tab type your name and email address.

     At Server -> Address type Smtp.gmail.com

     Configure the authentication method and click on test to test the configuration.

     (Here test will send the mail on specified mail address). Courtesy : Kaushik