topic How to do the YTD Report ? in QlikView https://community.qlik.com/t5/QlikView/How-to-do-the-YTD-Report/m-p/1251079#M871278 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><P>How to create Month and YTD Report like below image.<IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143905_Capture.PNG" style="height: 333px; width: 620px;" /></P><P></P><P>I have attached the Qlikview Model . Is the report correct for the 1st Month Report.</P><P>How to do the YTD Report ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT suvechha_b 2020-11-25T16:16:04Z How to do the YTD Report ? https://community.qlik.com/t5/QlikView/How-to-do-the-YTD-Report/m-p/1251079#M871278 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><P>How to create Month and YTD Report like below image.<IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143905_Capture.PNG" style="height: 333px; width: 620px;" /></P><P></P><P>I have attached the Qlikview Model . Is the report correct for the 1st Month Report.</P><P>How to do the YTD Report ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-YTD-Report/m-p/1251079#M871278 suvechha_b 2020-11-25T16:16:04Z Re: How to do the YTD Report ? https://community.qlik.com/t5/QlikView/How-to-do-the-YTD-Report/m-p/1251080#M871279 <HTML><HEAD></HEAD><BODY><P>Hi Use Set expression in your expression with date range (YTD Date Range)</P></BODY></HTML> Tue, 15 Nov 2016 09:37:51 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-YTD-Report/m-p/1251080#M871279 2016-11-15T09:37:51Z Re: How to do the YTD Report ? https://community.qlik.com/t5/QlikView/How-to-do-the-YTD-Report/m-p/1251081#M871280 <HTML><HEAD></HEAD><BODY><P>Hi Suvechha,</P><P>You can try this expression for 'PY Actual'</P><P><STRONG>=Sum(Aggr(if(Measure='Quantity',SUM({&lt;[Fiscal Year]={"=$(vPrevFiscalYear)"},[Type Indicator] = {'A'} &gt;} Quantity),SUM({&lt;[Fiscal Year]={"=$(vPrevFiscalYear)"},[Type Indicator] = {'A'} &gt;} [Sales Value])),&nbsp; Measure, Month))</STRONG></P></BODY></HTML> Tue, 15 Nov 2016 10:00:04 GMT https://community.qlik.com/t5/QlikView/How-to-do-the-YTD-Report/m-p/1251081#M871280 susovan 2016-11-15T10:00:04Z