send a list of values in a mail from alerts

[saumyashah90]

suppse i have

Header 1	Header 2
a	0
b	1
c	0
d	0
e	1

i want to send list of Header1 whose Header 2 is 0 in a mail

i have already configured mail , but problem is it just sends mail getting any aggregated value. like count,sum etc

Can any one help me in sending list of names

[kaushiknsolanki]

Hi,

     You can use the concat command to concat the values and send it through the alert mail.

Regards,

Kaushik Solanki

[saumyashah90]

hey kaushik,

i got it that that i can concatenate and give multiple values. But as i mention in the condition that i want to send list of Header1 whose value in Header2 is 0

[kaushiknsolanki]

Hi,

     You can use the set analysis with concat function to filter the set.

     So in your case you can try

     Concat({<Header2 = {"0"}>}Header1)

Regards,

Kaushik Solanki

[qlikpahadi07]

Hi Saumya,

if i am not wrong Alert Function will work only when Qv application get opened ?

Did you have done a Code like it will automatically send the mail? if yes please attach a Sample or simple Points will be helpful.

[saumyashah90]

For Mail

In Tools-> Alerts->Mail Recipients :type you email id

In Settings->User Preferences->Mail-> Configure your mail

Under Server-> Address-SMTP server address,Port -25,Authentication Method-None

Under Sender->Name,Email Id

Encoding-Western European(ISO)

check Send MIME encoded