https://community.qlik.com/t5/App-Development/Getting-Prev-FinYear-MaxMonth-figures/m-p/1900540#M74305 <P>Trying to get below expression which displays current FinYear MaxMonth to display Prev FinYear MaxMonth<BR /><BR />Variable Name:&nbsp;<STRONG>vDate_MaxYearMaxMonthMaxDay</STRONG></P> <P><STRONG>Expression:</STRONG></P> <P>=if(text(Date(MonthEnd(Date#($(vDate_MaxYYYYMMDD), 'YYYYMMDD')), 'YYYYMMDD')) <BR />= text(Date(Date#($(vDate_Global_MaxMonthEndYYYYMMDD), 'YYYYMMDD') , 'YYYYMMDD'))<BR />,max({&lt;CAL_YEARMONTHINDEX = {$(vDate_MaxYEARMONTHINDEX)}&gt;}DAY_NO)<BR />,if(GetSelectedCount(DAY_NO) &gt; 0 , max(DAY_NO),<BR />31))</P> <P>See breakdown of fields and variables used in attached snipper. Please ignore circled (Red).&nbsp;</P> Thu, 03 Mar 2022 11:41:25 GMT Mothapoe 2022-03-03T11:41:25Z https://community.qlik.com/t5/App-Development/Getting-Prev-FinYear-MaxMonth-figures/m-p/1900540#M74305 <P>Trying to get below expression which displays current FinYear MaxMonth to display Prev FinYear MaxMonth<BR /><BR />Variable Name:&nbsp;<STRONG>vDate_MaxYearMaxMonthMaxDay</STRONG></P> <P><STRONG>Expression:</STRONG></P> <P>=if(text(Date(MonthEnd(Date#($(vDate_MaxYYYYMMDD), 'YYYYMMDD')), 'YYYYMMDD')) <BR />= text(Date(Date#($(vDate_Global_MaxMonthEndYYYYMMDD), 'YYYYMMDD') , 'YYYYMMDD'))<BR />,max({&lt;CAL_YEARMONTHINDEX = {$(vDate_MaxYEARMONTHINDEX)}&gt;}DAY_NO)<BR />,if(GetSelectedCount(DAY_NO) &gt; 0 , max(DAY_NO),<BR />31))</P> <P>See breakdown of fields and variables used in attached snipper. Please ignore circled (Red).&nbsp;</P> Thu, 03 Mar 2022 11:41:25 GMT https://community.qlik.com/t5/App-Development/Getting-Prev-FinYear-MaxMonth-figures/m-p/1900540#M74305 Mothapoe 2022-03-03T11:41:25Z