topic Alert in QlikView https://community.qlik.com/t5/QlikView/Alert/m-p/876278#M305965 <HTML><HEAD></HEAD><BODY><P>Hi guys!</P><P></P><P>I have a table with Employee's name and his salary.</P><P></P><P>What kind of expression do I need to write in condition of Alert Wizard if I want a popping up alert whenever there is a mising value in salary?</P><P></P><P>IsNull(Salary) isnt working properly, it always shows me an alert though there are no missing values....</P></BODY></HTML> Tue, 21 Apr 2015 15:12:23 GMT 2015-04-21T15:12:23Z Alert https://community.qlik.com/t5/QlikView/Alert/m-p/876278#M305965 <HTML><HEAD></HEAD><BODY><P>Hi guys!</P><P></P><P>I have a table with Employee's name and his salary.</P><P></P><P>What kind of expression do I need to write in condition of Alert Wizard if I want a popping up alert whenever there is a mising value in salary?</P><P></P><P>IsNull(Salary) isnt working properly, it always shows me an alert though there are no missing values....</P></BODY></HTML> Tue, 21 Apr 2015 15:12:23 GMT https://community.qlik.com/t5/QlikView/Alert/m-p/876278#M305965 2015-04-21T15:12:23Z Re: Alert https://community.qlik.com/t5/QlikView/Alert/m-p/876279#M305966 <HTML><HEAD></HEAD><BODY><P>Hi Diana, depends on data model but maybe:</P><P>Count(Employee)&lt;&gt;Count(Salary)</P><P>or</P><P>Sum(Aggr(If(Count(Salary)=0, 1), Employee))&gt;1</P></BODY></HTML> Tue, 21 Apr 2015 15:16:32 GMT https://community.qlik.com/t5/QlikView/Alert/m-p/876279#M305966 rubenmarin 2015-04-21T15:16:32Z