topic Error in Set Modifier ad hoc element list in QlikView https://community.qlik.com/t5/QlikView/Error-in-Set-Modifier-ad-hoc-element-list/m-p/149011#M27222 <HTML><HEAD></HEAD><BODY><P>Good Afternoon,<BR /> I am trying to use Set Analysis on one of my charts to be able to count all the product from the last month. So if I open up the document on August, I would like to see the total amount of products there were in July. I have two fields in my database called Dateentered(format is: MM/YYYY) and Product(format is: text). So my code is as following:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=Count({&lt;Dateentered = {Monthstart(Today(), 1)}&gt;} Product )</PRE><BR /><BR /> <P>Unfortunately this does not work. I get "Error in set modifier ad hoc eleement list:" from the complier.</P><P>Not sure what I am doing wrong?</P><P></P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><BR /><BR /> <BR /><BR /></BODY></HTML> Fri, 10 Jul 2009 23:56:17 GMT 2009-07-10T23:56:17Z Error in Set Modifier ad hoc element list https://community.qlik.com/t5/QlikView/Error-in-Set-Modifier-ad-hoc-element-list/m-p/149011#M27222 <HTML><HEAD></HEAD><BODY><P>Good Afternoon,<BR /> I am trying to use Set Analysis on one of my charts to be able to count all the product from the last month. So if I open up the document on August, I would like to see the total amount of products there were in July. I have two fields in my database called Dateentered(format is: MM/YYYY) and Product(format is: text). So my code is as following:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">=Count({&lt;Dateentered = {Monthstart(Today(), 1)}&gt;} Product )</PRE><BR /><BR /> <P>Unfortunately this does not work. I get "Error in set modifier ad hoc eleement list:" from the complier.</P><P>Not sure what I am doing wrong?</P><P></P><P></P><P></P><P></P><P></P><P></P><BR /><BR /> <P></P><BR /><BR /> <BR /><BR /></BODY></HTML> Fri, 10 Jul 2009 23:56:17 GMT https://community.qlik.com/t5/QlikView/Error-in-Set-Modifier-ad-hoc-element-list/m-p/149011#M27222 2009-07-10T23:56:17Z Error in Set Modifier ad hoc element list https://community.qlik.com/t5/QlikView/Error-in-Set-Modifier-ad-hoc-element-list/m-p/149012#M27223 <HTML><HEAD></HEAD><BODY><P>I think you need a dollar sign expansion around that Monthstart function. That will force QlikView to evaluate the function before doing the Set Analysis.</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=Count({&lt;Dateentered = {$(Monthstart(Today(), 1))}&gt;} Product )</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Sat, 11 Jul 2009 01:28:02 GMT https://community.qlik.com/t5/QlikView/Error-in-Set-Modifier-ad-hoc-element-list/m-p/149012#M27223 2009-07-11T01:28:02Z