topic Set analysis syntax? in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-syntax/m-p/369310#M137295 <HTML><HEAD></HEAD><BODY><P>Is OPENDATE a month? or a complete date? Your variable is just returning e number. </P><P></P><P>You can't compare for example 10/12/2012 with 12</P></BODY></HTML> Mon, 26 Mar 2012 13:10:19 GMT jvitantonio 2012-03-26T13:10:19Z Set analysis syntax? https://community.qlik.com/t5/QlikView/Set-analysis-syntax/m-p/369309#M137294 <HTML><HEAD></HEAD><BODY><P>I am trying to create a set Analysis for a pivot table to return the previous months Enquiries from our CRM system</P><P>Every enquiry has an Openeddate</P><P>Below is what I have come up with, with the help of previous cases on here for similar requests. But it is not returning anything for me. Any ideas?</P><P></P><P><SPAN style="font-family: arial black,avant garde;">{&lt;OPENEDDATE = {"&gt;=$(=monthstart(addmonths(today(),-1)))&lt;$(=monthstart(today()))"}&gt;}</SPAN></P></BODY></HTML> Mon, 26 Mar 2012 13:03:50 GMT https://community.qlik.com/t5/QlikView/Set-analysis-syntax/m-p/369309#M137294 2012-03-26T13:03:50Z Set analysis syntax? https://community.qlik.com/t5/QlikView/Set-analysis-syntax/m-p/369310#M137295 <HTML><HEAD></HEAD><BODY><P>Is OPENDATE a month? or a complete date? Your variable is just returning e number. </P><P></P><P>You can't compare for example 10/12/2012 with 12</P></BODY></HTML> Mon, 26 Mar 2012 13:10:19 GMT https://community.qlik.com/t5/QlikView/Set-analysis-syntax/m-p/369310#M137295 jvitantonio 2012-03-26T13:10:19Z Re: Set analysis syntax? https://community.qlik.com/t5/QlikView/Set-analysis-syntax/m-p/369311#M137296 <HTML><HEAD></HEAD><BODY><P>Sorry, Openeddate is a date field in the database in the format DD/MM/YYYY</P></BODY></HTML> Mon, 26 Mar 2012 13:22:27 GMT https://community.qlik.com/t5/QlikView/Set-analysis-syntax/m-p/369311#M137296 2012-03-26T13:22:27Z Re: Set analysis syntax? https://community.qlik.com/t5/QlikView/Set-analysis-syntax/m-p/369312#M137297 <HTML><HEAD></HEAD><BODY><P>Whoops</P><P>User error</P><P>I had other items selected in the document <IMG src="https://community.qlik.com/legacyfs/online/emoticons/blush.png" /></P><P></P><P>The syntax for the set was correct all along</P></BODY></HTML> Mon, 26 Mar 2012 14:02:49 GMT https://community.qlik.com/t5/QlikView/Set-analysis-syntax/m-p/369312#M137297 2012-03-26T14:02:49Z