topic Re: alert in QlikView https://community.qlik.com/t5/QlikView/alert/m-p/1218249#M389903 <HTML><HEAD></HEAD><BODY><P>Hi Wiem</P><P></P><P>Could able provide the sample data ?</P><P>or</P><P>Could elaborate your need little more</P><P></P><P>Regards</P><P>Hemanth</P></BODY></HTML> Wed, 07 Dec 2016 09:45:52 GMT hemanthaanichet 2016-12-07T09:45:52Z alert https://community.qlik.com/t5/QlikView/alert/m-p/1218248#M389902 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P>I need your help as usual <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I would like to add an alert to one of my dashbords. This is the 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. A dimension Type should be selected</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">How to add&nbsp; this condition to my experssion?</SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"><BR /></SPAN></P><P><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">Thanks<BR /></SPAN></P></BODY></HTML> Wed, 07 Dec 2016 09:10:45 GMT https://community.qlik.com/t5/QlikView/alert/m-p/1218248#M389902 master_student 2016-12-07T09:10:45Z Re: alert https://community.qlik.com/t5/QlikView/alert/m-p/1218249#M389903 <HTML><HEAD></HEAD><BODY><P>Hi Wiem</P><P></P><P>Could able provide the sample data ?</P><P>or</P><P>Could elaborate your need little more</P><P></P><P>Regards</P><P>Hemanth</P></BODY></HTML> Wed, 07 Dec 2016 09:45:52 GMT https://community.qlik.com/t5/QlikView/alert/m-p/1218249#M389903 hemanthaanichet 2016-12-07T09:45:52Z Re: alert https://community.qlik.com/t5/QlikView/alert/m-p/1218250#M389904 <HTML><HEAD></HEAD><BODY><P>Add a textbox with your expression and format and make sure it is displaying correctly..</P><P></P><P>Then use conditional show hid</P><P>Textbox &gt; layout &gt; Enable Conditional and the the expression:</P><P>=getselectedcount(Yourfield) &lt;&gt; 0</P><P></P><P></P><P>Textbox &gt; layout &gt; Layer &gt; custom = 5</P><P></P><P>If the dimension is not selected, the alert will pop up</P></BODY></HTML> Wed, 07 Dec 2016 10:10:37 GMT https://community.qlik.com/t5/QlikView/alert/m-p/1218250#M389904 Anonymous 2016-12-07T10:10:37Z Re: alert https://community.qlik.com/t5/QlikView/alert/m-p/1218251#M389905 <HTML><HEAD></HEAD><BODY><P>where to add the <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">getselectedcount(Yourfield) &lt;&gt; 0 condition. here's my alert :</SPAN></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/145858_Capture.PNG" style="height: 436px; width: 620px;" /></P></BODY></HTML> Wed, 07 Dec 2016 11:15:03 GMT https://community.qlik.com/t5/QlikView/alert/m-p/1218251#M389905 master_student 2016-12-07T11:15:03Z