topic YTD Calculation in QlikView https://community.qlik.com/t5/QlikView/YTD-Calculation/m-p/285681#M106255 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have an AP table as </P><P></P><P>AP period Year&nbsp;&nbsp;&nbsp; startdate&nbsp;&nbsp; enddate</P><P>AP01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2012&nbsp;&nbsp; 2-Jan-12&nbsp;&nbsp; 31-Jan-12</P><P>AP02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2012&nbsp;&nbsp; 2-Feb-12&nbsp;&nbsp; 28-Feb-12</P><P></P><P>I need to calculate YTD calculation</P><P></P><P>Fact table has a field&nbsp; induction date.&nbsp; expression is&nbsp; sum (field)&nbsp; from&nbsp; today of induction date to start of the induction date of&nbsp; same year, <STRONG>but it should be till the&nbsp; AP start date. </STRONG></P><P></P><P><STRONG>for ex in above scenario induction date from today to 2-Jan-12&nbsp; should be taken as YTD should be used and sum(field) has to be calculated ...</STRONG></P><P></P><P>Field contains numeric value.</P><P></P><P>should i link induction date with AP start date..??</P><P></P><P>how to calculate YTD?? </P></BODY></HTML> Wed, 15 Feb 2012 15:32:52 GMT 2012-02-15T15:32:52Z YTD Calculation https://community.qlik.com/t5/QlikView/YTD-Calculation/m-p/285681#M106255 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have an AP table as </P><P></P><P>AP period Year&nbsp;&nbsp;&nbsp; startdate&nbsp;&nbsp; enddate</P><P>AP01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2012&nbsp;&nbsp; 2-Jan-12&nbsp;&nbsp; 31-Jan-12</P><P>AP02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2012&nbsp;&nbsp; 2-Feb-12&nbsp;&nbsp; 28-Feb-12</P><P></P><P>I need to calculate YTD calculation</P><P></P><P>Fact table has a field&nbsp; induction date.&nbsp; expression is&nbsp; sum (field)&nbsp; from&nbsp; today of induction date to start of the induction date of&nbsp; same year, <STRONG>but it should be till the&nbsp; AP start date. </STRONG></P><P></P><P><STRONG>for ex in above scenario induction date from today to 2-Jan-12&nbsp; should be taken as YTD should be used and sum(field) has to be calculated ...</STRONG></P><P></P><P>Field contains numeric value.</P><P></P><P>should i link induction date with AP start date..??</P><P></P><P>how to calculate YTD?? </P></BODY></HTML> Wed, 15 Feb 2012 15:32:52 GMT https://community.qlik.com/t5/QlikView/YTD-Calculation/m-p/285681#M106255 2012-02-15T15:32:52Z YTD Calculation https://community.qlik.com/t5/QlikView/YTD-Calculation/m-p/285682#M106256 <HTML><HEAD></HEAD><BODY><P>anyone is there ??</P><P></P><P>pls share your idea......</P></BODY></HTML> Wed, 15 Feb 2012 15:35:43 GMT https://community.qlik.com/t5/QlikView/YTD-Calculation/m-p/285682#M106256 2012-02-15T15:35:43Z Re: YTD Calculation https://community.qlik.com/t5/QlikView/YTD-Calculation/m-p/285683#M106257 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Hope the attached qv file will be solve your YTD calcualtion </P><P></P><P>Regards</P><P></P><P>Ashok</P></BODY></HTML> Thu, 16 Feb 2012 08:21:18 GMT https://community.qlik.com/t5/QlikView/YTD-Calculation/m-p/285683#M106257 Anonymous 2012-02-16T08:21:18Z