topic Issue with set analysis expression in QlikView https://community.qlik.com/t5/QlikView/Issue-with-set-analysis-expression/m-p/491793#M183824 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can someone please tell me what is wrong with the below statement</P><P></P><P>=sum({$&lt;CrimeYear = {$(vCrimeYear) - 1}, CrimeMonth = {"&lt;=$(vCrimeMonth)"}&gt;} Casenum )</P><P></P><P>Actually I have used the below expression for Current YTD</P><P></P><P>=sum({$&lt;CrimeYear = {$(vCrimeYear)}, CrimeMonth = {"&lt;=$(vCrimeMonth)"}&gt;} Casenum )</P><P></P><P>I wanted to have a Previous YTD so that I wondered if I could simply substract the year by one..$(vCrimeYear) - 1 but its not working. I am sure I am making a syntax mistake so I will appreciate if someone could correct my expression</P><P></P><P>Regards</P><P>Arif</P></BODY></HTML> Mon, 16 Dec 2013 19:47:22 GMT 2013-12-16T19:47:22Z Issue with set analysis expression https://community.qlik.com/t5/QlikView/Issue-with-set-analysis-expression/m-p/491793#M183824 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can someone please tell me what is wrong with the below statement</P><P></P><P>=sum({$&lt;CrimeYear = {$(vCrimeYear) - 1}, CrimeMonth = {"&lt;=$(vCrimeMonth)"}&gt;} Casenum )</P><P></P><P>Actually I have used the below expression for Current YTD</P><P></P><P>=sum({$&lt;CrimeYear = {$(vCrimeYear)}, CrimeMonth = {"&lt;=$(vCrimeMonth)"}&gt;} Casenum )</P><P></P><P>I wanted to have a Previous YTD so that I wondered if I could simply substract the year by one..$(vCrimeYear) - 1 but its not working. I am sure I am making a syntax mistake so I will appreciate if someone could correct my expression</P><P></P><P>Regards</P><P>Arif</P></BODY></HTML> Mon, 16 Dec 2013 19:47:22 GMT https://community.qlik.com/t5/QlikView/Issue-with-set-analysis-expression/m-p/491793#M183824 2013-12-16T19:47:22Z Re: Issue with set analysis expression https://community.qlik.com/t5/QlikView/Issue-with-set-analysis-expression/m-p/491794#M183825 <HTML><HEAD></HEAD><BODY><P>=sum({$&lt;CrimeYear = {$(=$(vCrimeYear) - 1)}, CrimeMonth = {"&lt;=$(vCrimeMonth)"}&gt;} Casenum )</P></BODY></HTML> Mon, 16 Dec 2013 19:59:15 GMT https://community.qlik.com/t5/QlikView/Issue-with-set-analysis-expression/m-p/491794#M183825 Nicole-Smith 2013-12-16T19:59:15Z