topic MTD Calculation in QlikView https://community.qlik.com/t5/QlikView/MTD-Calculation/m-p/167767#M588353 <HTML><HEAD></HEAD><BODY><P>How can I put the expression to calculate MTD? I have the following columns in the pivot table:-</P><P>Column 1 - Day ( 1, 2, 3, ... , 31)</P><P>Column 2 - Office</P><P>Column 3 - Daily Sales</P><P>Column 4 - MTD Sales (from day 1 to the day in column 1 above)</P><P></P></BODY></HTML> Fri, 18 Mar 2011 07:14:26 GMT Anonymous 2011-03-18T07:14:26Z MTD Calculation https://community.qlik.com/t5/QlikView/MTD-Calculation/m-p/167767#M588353 <HTML><HEAD></HEAD><BODY><P>How can I put the expression to calculate MTD? I have the following columns in the pivot table:-</P><P>Column 1 - Day ( 1, 2, 3, ... , 31)</P><P>Column 2 - Office</P><P>Column 3 - Daily Sales</P><P>Column 4 - MTD Sales (from day 1 to the day in column 1 above)</P><P></P></BODY></HTML> Fri, 18 Mar 2011 07:14:26 GMT https://community.qlik.com/t5/QlikView/MTD-Calculation/m-p/167767#M588353 Anonymous 2011-03-18T07:14:26Z MTD Calculation https://community.qlik.com/t5/QlikView/MTD-Calculation/m-p/167768#M588354 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Use above ( total .....) function.</P><P>Like</P><P>sum ( above ( total sales ) )</P><P>Reg,</P><P>Shubhu</P></BODY></HTML> Fri, 18 Mar 2011 07:24:06 GMT https://community.qlik.com/t5/QlikView/MTD-Calculation/m-p/167768#M588354 2011-03-18T07:24:06Z