topic Re: Expression Error in QlikView https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1452566#M611769 <HTML><HEAD></HEAD><BODY><P>Hi Agrim,</P><P></P><P>Try this,</P><P></P><P><STRONG>Count ({&lt;DIGIC -= {"No",""},[Is in MP]={"Yes"}&gt;} distinct [NAME OF PROJECT (Code - Title)])</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>You should add <IMG src="https://community.qlik.com/legacyfs/online/emoticons/minus.png" /> sign in-front of equal sign for DIGIC to exclude NO and Blank.<BR /></STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><BR /></STRONG></P><P></P></BODY></HTML> Mon, 16 Oct 2017 07:24:39 GMT srivastalans 2017-10-16T07:24:39Z ? https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1452564#M611767 <P>.</P> Sun, 14 Apr 2019 15:57:02 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1452564#M611767 xyz1 2019-04-14T15:57:02Z Re: Expression Error https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1452565#M611768 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">May be this <BR /></STRONG></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Count ({&lt;DIGIC = -{"Yes"},[Is in MP]={"Yes"}&gt;} distinct [NAME OF PROJECT (Code - Title)])</STRONG></P></BODY></HTML> Mon, 16 Oct 2017 07:09:34 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1452565#M611768 pradosh_thakur 2017-10-16T07:09:34Z Re: Expression Error https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1452566#M611769 <HTML><HEAD></HEAD><BODY><P>Hi Agrim,</P><P></P><P>Try this,</P><P></P><P><STRONG>Count ({&lt;DIGIC -= {"No",""},[Is in MP]={"Yes"}&gt;} distinct [NAME OF PROJECT (Code - Title)])</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>You should add <IMG src="https://community.qlik.com/legacyfs/online/emoticons/minus.png" /> sign in-front of equal sign for DIGIC to exclude NO and Blank.<BR /></STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><BR /></STRONG></P><P></P></BODY></HTML> Mon, 16 Oct 2017 07:24:39 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1452566#M611769 srivastalans 2017-10-16T07:24:39Z