topic Set analysis help! in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-help/m-p/317731#M584828 <HTML><HEAD></HEAD><BODY><P> Stefan...YOU'RE AWESOME!!</P></BODY></HTML> Thu, 01 Sep 2011 15:32:34 GMT samvile18 2011-09-01T15:32:34Z Set analysis help! https://community.qlik.com/t5/QlikView/Set-analysis-help/m-p/317729#M584826 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can anyone help me please?</P><P></P><P>I have the following syntax that I use to calculate a YTD Forecast figure, I need to change it so instead of it calculating up to todays date...it calculates up to 31/07/2011</P><P></P><P>=<SPAN style="color: #0000ff;">Sum</SPAN>({$&lt;<SPAN style="color: #800000;">Year </SPAN>= {2011},<SPAN style="color: #800000;">Measure</SPAN>={'Budget'}, <SPAN style="color: #800000;">Period</SPAN>={<SPAN style="color: #800000;">"&lt;=$</SPAN>(=<SPAN style="color: #800000;">Today())"</SPAN>}&gt;}<SPAN style="color: #800000;">Value</SPAN>)/1000</P><P></P><P>Many thanks in advance</P></BODY></HTML> Thu, 01 Sep 2011 15:24:42 GMT https://community.qlik.com/t5/QlikView/Set-analysis-help/m-p/317729#M584826 samvile18 2011-09-01T15:24:42Z Set analysis help! https://community.qlik.com/t5/QlikView/Set-analysis-help/m-p/317730#M584827 <HTML><HEAD></HEAD><BODY><P>Try replacing the today() with makedate(2011,07,31)</P><P></P><P>Stefan</P></BODY></HTML> Thu, 01 Sep 2011 15:29:01 GMT https://community.qlik.com/t5/QlikView/Set-analysis-help/m-p/317730#M584827 swuehl 2011-09-01T15:29:01Z Set analysis help! https://community.qlik.com/t5/QlikView/Set-analysis-help/m-p/317731#M584828 <HTML><HEAD></HEAD><BODY><P> Stefan...YOU'RE AWESOME!!</P></BODY></HTML> Thu, 01 Sep 2011 15:32:34 GMT https://community.qlik.com/t5/QlikView/Set-analysis-help/m-p/317731#M584828 samvile18 2011-09-01T15:32:34Z