topic Count Like in QlikView https://community.qlik.com/t5/QlikView/Count-Like/m-p/1155312#M906043 <HTML><HEAD></HEAD><BODY><P>Can someone tell me what's wrong with this statement?</P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">({</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">[AltState1]</SPAN><SPAN style="font-size: 8pt;">&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">STARTDATE_YYYY</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">like</SPAN><SPAN style="font-size: 8pt;"> {'2016*'}&gt;} CLT_CLT_PGMID) </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Count Like https://community.qlik.com/t5/QlikView/Count-Like/m-p/1155312#M906043 <HTML><HEAD></HEAD><BODY><P>Can someone tell me what's wrong with this statement?</P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">({</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">[AltState1]</SPAN><SPAN style="font-size: 8pt;">&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">STARTDATE_YYYY</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">like</SPAN><SPAN style="font-size: 8pt;"> {'2016*'}&gt;} CLT_CLT_PGMID) </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Count-Like/m-p/1155312#M906043 Anonymous 2020-11-25T16:16:04Z Re: Count Like https://community.qlik.com/t5/QlikView/Count-Like/m-p/1155313#M906044 <HTML><HEAD></HEAD><BODY><P>It's just not valid syntax for a field modifier.</P><P></P><P>Try</P><P></P><P><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">Count</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">( {</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #0000ff;">[AltState1]</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&lt;</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #800000;">STARTDATE_YYYY</SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> </SPAN><SPAN style="color: #0000ff; font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">= </SPAN><SPAN style="font-size: 8pt; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> {"2016*"}&gt;} CLT_CLT_PGMID)</SPAN></P></BODY></HTML> Mon, 20 Jun 2016 19:14:31 GMT https://community.qlik.com/t5/QlikView/Count-Like/m-p/1155313#M906044 swuehl 2016-06-20T19:14:31Z