topic Re: Re: How to calculate MTD/YTD in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-MTD-YTD/m-p/309984#M114460 <HTML><HEAD></HEAD><BODY><P>Hi perumal ,</P><P>plz find below attachment for ytd</P></BODY></HTML> Thu, 24 Jul 2014 08:25:11 GMT 2014-07-24T08:25:11Z How to calculate MTD/YTD https://community.qlik.com/t5/QlikView/How-to-calculate-MTD-YTD/m-p/309980#M114456 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>&nbsp;&nbsp;&nbsp; Hope so al doing well.</P><P>&nbsp;&nbsp;&nbsp; I need help for MTD/YTD Calculations,but i need to calculate in back end itself.Because i want to reduce the front end expressions</P><P>&nbsp;&nbsp;&nbsp; is ther any way to do it.</P><P></P><P>Regards,</P><P>Santhosh Kumar G</P></BODY></HTML> Wed, 27 Jul 2011 05:22:11 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-MTD-YTD/m-p/309980#M114456 2011-07-27T05:22:11Z How to calculate MTD/YTD https://community.qlik.com/t5/QlikView/How-to-calculate-MTD-YTD/m-p/309981#M114457 <HTML><HEAD></HEAD><BODY><P>Use the below script</P><P></P><P>Load</P><P>If(InYearToDate([Date_Field],today(),0),true(),false()) as YTD,</P><P>If(InMonthToDate([Date_Field],today(),0),true(),false()) as MTD</P><P>From......</P><P></P><P>[Date_Field] - Date used in your application.</P><P></P><P>You can use the YTD or MTD value in Front end like, Sum(SalesAmount*YTD) or Sum(SalesAmount*MTD) which gives you the sum of sales amount for the year till date or month till date respectively...</P></BODY></HTML> Wed, 27 Jul 2011 07:04:47 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-MTD-YTD/m-p/309981#M114457 Anonymous 2011-07-27T07:04:47Z Re: How to calculate MTD/YTD https://community.qlik.com/t5/QlikView/How-to-calculate-MTD-YTD/m-p/309982#M114458 <HTML><HEAD></HEAD><BODY><P>I have attached one file .Please check helpful for MTD/YTD&nbsp; Calculation</P><P></P><P>Regards,</P><P></P><P>Perumal</P></BODY></HTML> Wed, 27 Jul 2011 07:31:02 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-MTD-YTD/m-p/309982#M114458 perumal_41 2011-07-27T07:31:02Z How to calculate MTD/YTD https://community.qlik.com/t5/QlikView/How-to-calculate-MTD-YTD/m-p/309983#M114459 <HTML><HEAD></HEAD><BODY><P>Thank you Mr.Perumal</P></BODY></HTML> Wed, 27 Jul 2011 08:01:07 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-MTD-YTD/m-p/309983#M114459 2011-07-27T08:01:07Z Re: Re: How to calculate MTD/YTD https://community.qlik.com/t5/QlikView/How-to-calculate-MTD-YTD/m-p/309984#M114460 <HTML><HEAD></HEAD><BODY><P>Hi perumal ,</P><P>plz find below attachment for ytd</P></BODY></HTML> Thu, 24 Jul 2014 08:25:11 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-MTD-YTD/m-p/309984#M114460 2014-07-24T08:25:11Z