topic YTD value from not regular calendar in QlikView https://community.qlik.com/t5/QlikView/YTD-value-from-not-regular-calendar/m-p/1369666#M1250278 <HTML><HEAD></HEAD><BODY><P>Hello Folks,</P><P></P><P></P><P>I am facing an issue while deriving value for YTD. My scenario is like blow.</P><P></P><P><STRONG>Ex:</STRONG> <STRONG>Fiscal Year 2017</STRONG> starts from <STRONG>July 1, 2016</STRONG> and ends on <STRONG>June 30, 2017</STRONG>. So range of months is from July 16 to June 17. </P><P></P><P>I need to get YTD value from start month to last moth which is value from start month July 2016 to May 2017 only. </P><P></P><P>I can consider min(month_column) as start month but I am unable get value till last month dynamically. </P><P></P><P></P><P></P><P>Can anyone help me out. </P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT 2026-01-26T18:19:17Z YTD value from not regular calendar https://community.qlik.com/t5/QlikView/YTD-value-from-not-regular-calendar/m-p/1369666#M1250278 <HTML><HEAD></HEAD><BODY><P>Hello Folks,</P><P></P><P></P><P>I am facing an issue while deriving value for YTD. My scenario is like blow.</P><P></P><P><STRONG>Ex:</STRONG> <STRONG>Fiscal Year 2017</STRONG> starts from <STRONG>July 1, 2016</STRONG> and ends on <STRONG>June 30, 2017</STRONG>. So range of months is from July 16 to June 17. </P><P></P><P>I need to get YTD value from start month to last moth which is value from start month July 2016 to May 2017 only. </P><P></P><P>I can consider min(month_column) as start month but I am unable get value till last month dynamically. </P><P></P><P></P><P></P><P>Can anyone help me out. </P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/YTD-value-from-not-regular-calendar/m-p/1369666#M1250278 2026-01-26T18:19:17Z