topic Re: alert in QlikView https://community.qlik.com/t5/QlikView/alert/m-p/1258851#M624098 <HTML><HEAD></HEAD><BODY><P>What kind of alert are you looking to create?</P></BODY></HTML> Wed, 14 Dec 2016 09:43:38 GMT sunny_talwar 2016-12-14T09:43:38Z alert https://community.qlik.com/t5/QlikView/alert/m-p/1258850#M624097 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>How to create an alert with condition a field must be selected ? here is my expression : <SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">=((</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">count</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">DISTINCT</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">[Code cas]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">) -</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">count</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"> (</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">distinct</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">[Concern. MSISDN]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">) )/ </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">count</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"> (</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">distinct</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">[Concern. MSISDN]</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">))*100 &gt;10</SPAN></P><P></P><P>Thanks</P></BODY></HTML> Wed, 14 Dec 2016 09:39:49 GMT https://community.qlik.com/t5/QlikView/alert/m-p/1258850#M624097 master_student 2016-12-14T09:39:49Z Re: alert https://community.qlik.com/t5/QlikView/alert/m-p/1258851#M624098 <HTML><HEAD></HEAD><BODY><P>What kind of alert are you looking to create?</P></BODY></HTML> Wed, 14 Dec 2016 09:43:38 GMT https://community.qlik.com/t5/QlikView/alert/m-p/1258851#M624098 sunny_talwar 2016-12-14T09:43:38Z Re: alert https://community.qlik.com/t5/QlikView/alert/m-p/1258852#M624099 <HTML><HEAD></HEAD><BODY><P>a pop up when opening the qlikview document</P></BODY></HTML> Wed, 14 Dec 2016 09:45:56 GMT https://community.qlik.com/t5/QlikView/alert/m-p/1258852#M624099 master_student 2016-12-14T09:45:56Z Re: alert https://community.qlik.com/t5/QlikView/alert/m-p/1258853#M624100 <HTML><HEAD></HEAD><BODY><P>So are you saying that you want this pop up to show only if a particular field in the dashboard have selections made in it?</P></BODY></HTML> Wed, 14 Dec 2016 09:49:11 GMT https://community.qlik.com/t5/QlikView/alert/m-p/1258853#M624100 sunny_talwar 2016-12-14T09:49:11Z Re: alert https://community.qlik.com/t5/QlikView/alert/m-p/1258854#M624101 <HTML><HEAD></HEAD><BODY><P>yes</P></BODY></HTML> Wed, 14 Dec 2016 09:52:07 GMT https://community.qlik.com/t5/QlikView/alert/m-p/1258854#M624101 master_student 2016-12-14T09:52:07Z Re: alert https://community.qlik.com/t5/QlikView/alert/m-p/1258855#M624103 <HTML><HEAD></HEAD><BODY><P>If it is for a particular field</P><P></P><P><STRONG>=((Count(DISTINCT [Code cas]) -Count(<STRONG style="font-size: 13.3333px;">DISTINCT </STRONG>[Concern. MSISDN]) )/ Count(<STRONG style="font-size: 13.3333px;">DISTINCT </STRONG>[Concern. MSISDN]))*100 &gt;10 and GetSelectedCount(FieldName) &gt; 0</STRONG></P></BODY></HTML> Wed, 14 Dec 2016 09:59:29 GMT https://community.qlik.com/t5/QlikView/alert/m-p/1258855#M624103 sunny_talwar 2016-12-14T09:59:29Z