https://community.qlik.com/t5/QlikView/Help-with-alerts-alert-based-off-null-value/m-p/204400#M61330 <HTML><HEAD></HEAD><BODY><P>Assuming I have a sql statement that joins two tables Table A1 &amp; Table B2</P><P>Table A1</P><P>ID DATETIME</P><P>A 4/6/2010 7:17:09</P><P>B 4/6/2010 7:16:09</P><P>C 4/6/2010 7:15:09</P><P>Table B2</P><P>ID REF</P><P>A</P><P>B 12</P><P>C 13</P><P>Joined A1 &amp; B2</P><P>ID DATETIME REF</P><P>A 4/6/2010 7:17:09</P><P>B 4/6/2010 7:16:09 12</P><P>C 4/6/2010 7:15:09 13</P><P>I would like an alert that A does not have a REF value.</P><P>Any thoughts? Feel free to change up anything to make it work!</P><P>-Michael</P></BODY></HTML> Tue, 06 Apr 2010 20:13:04 GMT mellerbeck 2010-04-06T20:13:04Z https://community.qlik.com/t5/QlikView/Help-with-alerts-alert-based-off-null-value/m-p/204400#M61330 <HTML><HEAD></HEAD><BODY><P>Assuming I have a sql statement that joins two tables Table A1 &amp; Table B2</P><P>Table A1</P><P>ID DATETIME</P><P>A 4/6/2010 7:17:09</P><P>B 4/6/2010 7:16:09</P><P>C 4/6/2010 7:15:09</P><P>Table B2</P><P>ID REF</P><P>A</P><P>B 12</P><P>C 13</P><P>Joined A1 &amp; B2</P><P>ID DATETIME REF</P><P>A 4/6/2010 7:17:09</P><P>B 4/6/2010 7:16:09 12</P><P>C 4/6/2010 7:15:09 13</P><P>I would like an alert that A does not have a REF value.</P><P>Any thoughts? Feel free to change up anything to make it work!</P><P>-Michael</P></BODY></HTML> Tue, 06 Apr 2010 20:13:04 GMT https://community.qlik.com/t5/QlikView/Help-with-alerts-alert-based-off-null-value/m-p/204400#M61330 mellerbeck 2010-04-06T20:13:04Z https://community.qlik.com/t5/QlikView/Help-with-alerts-alert-based-off-null-value/m-p/204401#M61331 <HTML><HEAD></HEAD><BODY><P>Bump, is this impossible? Or should I handle it differently?</P></BODY></HTML> Wed, 07 Apr 2010 16:39:57 GMT https://community.qlik.com/t5/QlikView/Help-with-alerts-alert-based-off-null-value/m-p/204401#M61331 mellerbeck 2010-04-07T16:39:57Z