topic alert message with condition in QlikView https://community.qlik.com/t5/QlikView/alert-message-with-condition/m-p/400979#M1165118 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a trouble with creating a condition in the message for alert firing.</P><P></P><P>I have data:</P><P>report name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; alert ind</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALERT</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P><P></P><P>I set the alert so that whenever there is ALER in the alert_ind it should fire. And it does, however I would like to have the message "report A needs to be refreshed".</P><P></P><P>I tried to use ='report ' &amp; if(alert_ind = 'ALERT', [report name]) &amp; 'needs to be refreshed' however this message pops up without A inside..</P><P>Can you please help?</P><P>Thanks a lot.</P><P>J,</P></BODY></HTML> Mon, 05 Nov 2012 10:16:11 GMT 2012-11-05T10:16:11Z alert message with condition https://community.qlik.com/t5/QlikView/alert-message-with-condition/m-p/400979#M1165118 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a trouble with creating a condition in the message for alert firing.</P><P></P><P>I have data:</P><P>report name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; alert ind</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ALERT</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P><P></P><P>I set the alert so that whenever there is ALER in the alert_ind it should fire. And it does, however I would like to have the message "report A needs to be refreshed".</P><P></P><P>I tried to use ='report ' &amp; if(alert_ind = 'ALERT', [report name]) &amp; 'needs to be refreshed' however this message pops up without A inside..</P><P>Can you please help?</P><P>Thanks a lot.</P><P>J,</P></BODY></HTML> Mon, 05 Nov 2012 10:16:11 GMT https://community.qlik.com/t5/QlikView/alert-message-with-condition/m-p/400979#M1165118 2012-11-05T10:16:11Z Re: alert message with condition https://community.qlik.com/t5/QlikView/alert-message-with-condition/m-p/400980#M1165119 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try to put only([report name])</P><P></P><P>TMF</P></BODY></HTML> Mon, 05 Nov 2012 16:05:15 GMT https://community.qlik.com/t5/QlikView/alert-message-with-condition/m-p/400980#M1165119 2012-11-05T16:05:15Z