topic Re: Mtd,Ytd in QlikView https://community.qlik.com/t5/QlikView/Mtd-Ytd/m-p/959438#M649640 <HTML><HEAD></HEAD><BODY><P>Have a look here:</P><P><A href="https://community.qlik.com/qlik-blogpost/3157">Relative Calendar Fields</A></P></BODY></HTML> Thu, 20 Aug 2015 06:48:19 GMT jonathandienst 2015-08-20T06:48:19Z Mtd,Ytd https://community.qlik.com/t5/QlikView/Mtd-Ytd/m-p/959437#M649639 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am working on ytd,mtd calcuation in script level.</P><P></P><P> Below is my script.</P><P>I am getting the day values which are correct .But my ytd ,mtd are wrong values.Please correct if my formula is wrong.</P><P></P><P>Load *, 'YTD' as TimeGranule </P><P>Resident Cal where Date &gt;=YearStart(TempDate) and Date&lt;=TempDate;</P><P></P><P>Load *, 'MTD' as TimeGranule </P><P>Resident Cal where Date &gt;= MonthStart(TempDate) and Date &lt;= TempDate;</P><P></P><P>Load * , 'Day' as TimeGranule </P><P>Resident Cal</P><P>where Date=TempDate;</P><P></P><P></P><P>Thanks</P></BODY></HTML> Thu, 20 Aug 2015 06:34:37 GMT https://community.qlik.com/t5/QlikView/Mtd-Ytd/m-p/959437#M649639 Anonymous 2015-08-20T06:34:37Z Re: Mtd,Ytd https://community.qlik.com/t5/QlikView/Mtd-Ytd/m-p/959438#M649640 <HTML><HEAD></HEAD><BODY><P>Have a look here:</P><P><A href="https://community.qlik.com/qlik-blogpost/3157">Relative Calendar Fields</A></P></BODY></HTML> Thu, 20 Aug 2015 06:48:19 GMT https://community.qlik.com/t5/QlikView/Mtd-Ytd/m-p/959438#M649640 jonathandienst 2015-08-20T06:48:19Z