https://community.qlik.com/t5/QlikView/QTD-Calculation/m-p/1818840#M1213265 <P>I need it in backend script</P> Wed, 30 Jun 2021 12:26:56 GMT arusiva89 2021-06-30T12:26:56Z https://community.qlik.com/t5/QlikView/QTD-Calculation/m-p/1818799#M1213257 <P>&nbsp;I want to build the QTD logic by accumulating the MTD values..MTD values are stored in the QVD..I want to fetch the month end of each month (Say for example - for Q1 2021- Jan 31,Feb 28,Mar 31 values should be added for QTD).How can I achieve it with existing QVD which has MTD values .I want to populate the values from backend only.Any ideas/suggestions ?</P><P>Existing QVD&nbsp;</P><P>Country Date Sales</P><P>A,2021-01-01,100</P><P>A,2021-01-02,200 (MTD values - Accumulation of 1st &amp; 2nd of Jan)</P><P>..</P><P>..</P><P>A,2021-01-31,150000 (MTD values)</P><P>&nbsp;</P><P>Expected QVD:</P><P>Country Date Sales</P><P>A,2021-03-31,10000000 (Sum of Jan 31+Feb 28+Mar 31 value)</P> Wed, 30 Jun 2021 12:28:44 GMT https://community.qlik.com/t5/QlikView/QTD-Calculation/m-p/1818799#M1213257 arusiva89 2021-06-30T12:28:44Z https://community.qlik.com/t5/QlikView/QTD-Calculation/m-p/1818803#M1213258 <P>=Sum({&lt;Quarter = {'Q1'}&gt;}Value)</P> Wed, 30 Jun 2021 10:26:32 GMT https://community.qlik.com/t5/QlikView/QTD-Calculation/m-p/1818803#M1213258 dineshm030 2021-06-30T10:26:32Z https://community.qlik.com/t5/QlikView/QTD-Calculation/m-p/1818840#M1213265 <P>I need it in backend script</P> Wed, 30 Jun 2021 12:26:56 GMT https://community.qlik.com/t5/QlikView/QTD-Calculation/m-p/1818840#M1213265 arusiva89 2021-06-30T12:26:56Z