topic Calculate YTD to MTD in script in QlikView https://community.qlik.com/t5/QlikView/Calculate-YTD-to-MTD-in-script/m-p/548110#M482596 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need your help. I have YTD data. I want to create MTD from YTD. Can I do that?</P><P>I want the data processed in script, not in expression. After this finished, expressions are much easier. And I'm stuck hehehe...</P><P>I attached the qvw in here.</P><P>Please kindly your help.</P><P>Note: the "Date" column is in month data. 1/1/2012 means jan 1, 2012. 2/1/2012 means feb 1, 2012. This BI is for our group, that's why we have more than 1 company in this sample. </P><P></P><P>Thanks &amp; Regards,</P><P>Wiwin</P></BODY></HTML> Thu, 01 Aug 2013 10:13:53 GMT 2013-08-01T10:13:53Z Calculate YTD to MTD in script https://community.qlik.com/t5/QlikView/Calculate-YTD-to-MTD-in-script/m-p/548110#M482596 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need your help. I have YTD data. I want to create MTD from YTD. Can I do that?</P><P>I want the data processed in script, not in expression. After this finished, expressions are much easier. And I'm stuck hehehe...</P><P>I attached the qvw in here.</P><P>Please kindly your help.</P><P>Note: the "Date" column is in month data. 1/1/2012 means jan 1, 2012. 2/1/2012 means feb 1, 2012. This BI is for our group, that's why we have more than 1 company in this sample. </P><P></P><P>Thanks &amp; Regards,</P><P>Wiwin</P></BODY></HTML> Thu, 01 Aug 2013 10:13:53 GMT https://community.qlik.com/t5/QlikView/Calculate-YTD-to-MTD-in-script/m-p/548110#M482596 2013-08-01T10:13:53Z