topic Disregarding today and yesterday in QlikView https://community.qlik.com/t5/QlikView/Disregarding-today-and-yesterday/m-p/703147#M253664 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>I have a chart that has the dimension the months of the year, I need in the current month today and yesterday are disregarded in the calculation, it is possible to do this using Set Analysis or other function? The dimension day, week, etc is avaliable too.</P></BODY></HTML> Wed, 03 Sep 2014 15:34:11 GMT 2014-09-03T15:34:11Z Disregarding today and yesterday https://community.qlik.com/t5/QlikView/Disregarding-today-and-yesterday/m-p/703147#M253664 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>I have a chart that has the dimension the months of the year, I need in the current month today and yesterday are disregarded in the calculation, it is possible to do this using Set Analysis or other function? The dimension day, week, etc is avaliable too.</P></BODY></HTML> Wed, 03 Sep 2014 15:34:11 GMT https://community.qlik.com/t5/QlikView/Disregarding-today-and-yesterday/m-p/703147#M253664 2014-09-03T15:34:11Z Re: Disregarding today and yesterday https://community.qlik.com/t5/QlikView/Disregarding-today-and-yesterday/m-p/703148#M253665 <HTML><HEAD></HEAD><BODY><P>What you want? MTD, YTD ? What is the measure?</P><P></P><P>You can have something like below for YTD</P><P></P><P>SUM({&lt;Date = {"&gt;=$(=YearStart(Today()))&lt;=$(=Date(Today()-2))"}&gt;}Amount)</P><P></P><P>For MTD</P><P></P><P>SUM({&lt;Date = {"&gt;=$(=MonthStart(Today()))&lt;=$(=Date(Today()-2))"}&gt;}Amount)</P></BODY></HTML> Wed, 03 Sep 2014 15:36:52 GMT https://community.qlik.com/t5/QlikView/Disregarding-today-and-yesterday/m-p/703148#M253665 MK_QSL 2014-09-03T15:36:52Z