topic set analysis in QlikView https://community.qlik.com/t5/QlikView/set-analysis/m-p/141664#M21279 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I want to use set analysis for FTD,MTD,YTD calculations.</P><P>If anybody can provide script for this,would be great !</P><P></P><P>Regards</P><P>Praveen</P></BODY></HTML> Fri, 17 Apr 2009 13:50:08 GMT 2009-04-17T13:50:08Z set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/141664#M21279 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I want to use set analysis for FTD,MTD,YTD calculations.</P><P>If anybody can provide script for this,would be great !</P><P></P><P>Regards</P><P>Praveen</P></BODY></HTML> Fri, 17 Apr 2009 13:50:08 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/141664#M21279 2009-04-17T13:50:08Z set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/141665#M21280 <HTML><HEAD></HEAD><BODY><P>Hi Praveen,</P><P>Below code will help you to do the requirement.</P><P><I>MTD</I> <B>= sum({$&lt;Month_Year={"$(=monthname(today()))"}&gt;} Sales)</B></P><P>YTD <B>= sum({$&lt;Fin_Year={"$(=(yearname(today(),0,10)))"}&gt;} Sales)</B></P><P>Regards</P><P>Sridhar<IMG alt="Yes" src="http://community.qlik.com/emoticons/emotion-21.gif" /></P></BODY></HTML> Fri, 17 Apr 2009 14:19:30 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/141665#M21280 2009-04-17T14:19:30Z