topic Set Analysis not working, why? in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-not-working-why/m-p/1402288#M424935 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Hi Community<BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">I'm trying to solve a problem using Set Analysis. I want to count the number of rows that a certain value appears.<BR /><BR />I'm writing this way:<BR /><BR />= Num (count ({($ &lt;columnname = 'String'&gt;} NrLine)<BR /><BR />In Load I created a function RecNo () as NrLine.<BR /><BR />The error it gives me is Error in set modifier ad hoc element list: ',' or ')' but I can not find the place to put it.</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">Thank you,</SPAN></P><P><SPAN lang="en">Regards</SPAN></P><P><SPAN lang="en">Bruno Paulo<BR /></SPAN></P></BODY></HTML> Sat, 23 Sep 2017 13:06:18 GMT brunopaulo 2017-09-23T13:06:18Z Set Analysis not working, why? https://community.qlik.com/t5/QlikView/Set-Analysis-not-working-why/m-p/1402288#M424935 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en">Hi Community<BR /></SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">I'm trying to solve a problem using Set Analysis. I want to count the number of rows that a certain value appears.<BR /><BR />I'm writing this way:<BR /><BR />= Num (count ({($ &lt;columnname = 'String'&gt;} NrLine)<BR /><BR />In Load I created a function RecNo () as NrLine.<BR /><BR />The error it gives me is Error in set modifier ad hoc element list: ',' or ')' but I can not find the place to put it.</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">Thank you,</SPAN></P><P><SPAN lang="en">Regards</SPAN></P><P><SPAN lang="en">Bruno Paulo<BR /></SPAN></P></BODY></HTML> Sat, 23 Sep 2017 13:06:18 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-not-working-why/m-p/1402288#M424935 brunopaulo 2017-09-23T13:06:18Z Re: Set Analysis not working, why? https://community.qlik.com/t5/QlikView/Set-Analysis-not-working-why/m-p/1402289#M424936 <HTML><HEAD></HEAD><BODY><P>Look at my response here:</P><P><A href="https://community.qlik.com/message/1350347">Re: Set Analysis problem on syntax</A></P></BODY></HTML> Mon, 25 Sep 2017 12:18:03 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-not-working-why/m-p/1402289#M424936 sunny_talwar 2017-09-25T12:18:03Z