topic Re: change count statement to if condition in QlikView https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1430843#M612111 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Count(</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>If(Match</STRONG>([Feasibility Planned] , '0', '1', '2') <STRONG>and</STRONG> <STRONG>Match</STRONG>([Updated Phase],'Feasibility') ,&nbsp; [NAME OF PROJECT (Code - Title)])<STRONG>)</STRONG></SPAN></P></BODY></HTML> Wed, 25 Oct 2017 11:58:28 GMT tresB 2017-10-25T11:58:28Z ? https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1430842#M612110 <P>.</P> Sun, 14 Apr 2019 15:46:31 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1430842#M612110 xyz1 2019-04-14T15:46:31Z Re: change count statement to if condition https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1430843#M612111 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Count(</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>If(Match</STRONG>([Feasibility Planned] , '0', '1', '2') <STRONG>and</STRONG> <STRONG>Match</STRONG>([Updated Phase],'Feasibility') ,&nbsp; [NAME OF PROJECT (Code - Title)])<STRONG>)</STRONG></SPAN></P></BODY></HTML> Wed, 25 Oct 2017 11:58:28 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1430843#M612111 tresB 2017-10-25T11:58:28Z ? https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1430844#M612112 <P>.</P> Sun, 14 Apr 2019 15:45:53 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1430844#M612112 xyz1 2019-04-14T15:45:53Z Re: change count statement to if condition https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1430845#M612113 <HTML><HEAD></HEAD><BODY><P>No, it would be:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">if(</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>( </STRONG>[Feasibility Planned]='0' <STRONG>OR</STRONG>&nbsp; [Feasibility Planned]='1' <STRONG>OR</STRONG> [Feasibility Planned]='2' <STRONG>)</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>AND&nbsp; </STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">[Updated Phase]= 'Feasibility'</SPAN> , [NAME OF PROJECT (Code - Title)]</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">)</P></BODY></HTML> Wed, 25 Oct 2017 12:14:45 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1430845#M612113 tresB 2017-10-25T12:14:45Z