topic YTD set analysis with Day selection in QlikView https://community.qlik.com/t5/QlikView/YTD-set-analysis-with-Day-selection/m-p/222072#M74818 <HTML><HEAD></HEAD><BODY><P>Hi guys!</P><P>I have a question regarding YTD using set analysis. I have this expression:</P><P>sum ({$&lt;Year = {$(=max(Year))}, Month = {"&lt;=$(=max({&lt;Year={$(=max(Year))}&gt;} Month))"}&gt;} Sales)</P><P>but I need to consider Day selection too. How can I do that?</P><P></P><P>Hope that you can help me with my problem.. Thanks in advance!</P><P></P><P>Lester</P><P></P></BODY></HTML> Wed, 29 Sep 2010 14:04:04 GMT 2010-09-29T14:04:04Z YTD set analysis with Day selection https://community.qlik.com/t5/QlikView/YTD-set-analysis-with-Day-selection/m-p/222072#M74818 <HTML><HEAD></HEAD><BODY><P>Hi guys!</P><P>I have a question regarding YTD using set analysis. I have this expression:</P><P>sum ({$&lt;Year = {$(=max(Year))}, Month = {"&lt;=$(=max({&lt;Year={$(=max(Year))}&gt;} Month))"}&gt;} Sales)</P><P>but I need to consider Day selection too. How can I do that?</P><P></P><P>Hope that you can help me with my problem.. Thanks in advance!</P><P></P><P>Lester</P><P></P></BODY></HTML> Wed, 29 Sep 2010 14:04:04 GMT https://community.qlik.com/t5/QlikView/YTD-set-analysis-with-Day-selection/m-p/222072#M74818 2010-09-29T14:04:04Z Re. :YTD set analysis with Day selection https://community.qlik.com/t5/QlikView/YTD-set-analysis-with-Day-selection/m-p/222073#M74819 <HTML><HEAD></HEAD><BODY><P>Hi Lester,</P><P>You can try this :</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">sum({&lt;Date={"&gt;=$(=date(YearStart(Max(Date)))) &lt;=$(=Max(Date))"}, Year=, Month=, Day=&gt;} Sales)</PRE></BLOCKQUOTE><BR /><BR /> <P></P></BODY></HTML> Wed, 29 Sep 2010 14:56:12 GMT https://community.qlik.com/t5/QlikView/YTD-set-analysis-with-Day-selection/m-p/222073#M74819 martin59 2010-09-29T14:56:12Z Re. :YTD set analysis with Day selection https://community.qlik.com/t5/QlikView/YTD-set-analysis-with-Day-selection/m-p/222074#M74820 <HTML><HEAD></HEAD><BODY><P>Thanks Martin!</P><P>I can also use your set analysis to my MTD just by replacing YearStart to MonthStart, and this also gives me some idea on my other expressions!</P><P></P><P>tyvm!</P><P></P><P>Regards,</P><P>Lester</P><P></P></BODY></HTML> Thu, 30 Sep 2010 02:25:44 GMT https://community.qlik.com/t5/QlikView/YTD-set-analysis-with-Day-selection/m-p/222074#M74820 2010-09-30T02:25:44Z