topic Get YTD for any selected month dimension in QlikView https://community.qlik.com/t5/QlikView/Get-YTD-for-any-selected-month-dimension/m-p/1354752#M822330 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a simple table with a single time dimension, Period, in format Mmm YYYY</P><P></P><P>I also have a single measure, Val</P><P></P><P>I want to create a simple chart with two expressions.</P><P></P><P>One will show the Sum(Val) for a selected period (or total Sum(Val) for all periods if no period selected) - straightforward enough.</P><P></P><P>The second will show the Sum(Val) for the YTD up to and including the selected Period. Again, this will&nbsp; simply show the total Sum(Val) of all periods if no selection made.</P><P></P><P>But I want this to work for any period selection (so max(Period) is not an option as the selected period will not necessarily be the latest period.</P><P></P><P>Any ideas?</P><P></P><P>Joe</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT mazacini 2020-11-25T16:16:04Z Get YTD for any selected month dimension https://community.qlik.com/t5/QlikView/Get-YTD-for-any-selected-month-dimension/m-p/1354752#M822330 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a simple table with a single time dimension, Period, in format Mmm YYYY</P><P></P><P>I also have a single measure, Val</P><P></P><P>I want to create a simple chart with two expressions.</P><P></P><P>One will show the Sum(Val) for a selected period (or total Sum(Val) for all periods if no period selected) - straightforward enough.</P><P></P><P>The second will show the Sum(Val) for the YTD up to and including the selected Period. Again, this will&nbsp; simply show the total Sum(Val) of all periods if no selection made.</P><P></P><P>But I want this to work for any period selection (so max(Period) is not an option as the selected period will not necessarily be the latest period.</P><P></P><P>Any ideas?</P><P></P><P>Joe</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Get-YTD-for-any-selected-month-dimension/m-p/1354752#M822330 mazacini 2020-11-25T16:16:04Z