https://community.qlik.com/t5/App-Development/Previous-Year-set/m-p/1818521#M67080 <P>Hello,</P><P>I'd like to write a set sum expression where the chart always shows 1 year previous to the selected year.&nbsp; I want to have the multi year chart so the expression below does not work&nbsp;</P><P>Sum({$&lt;[Date-Posting Date.autoCalendar.Year] = {$(=Year(Today())-1)}&gt;}[Expenses])</P><P>where the chart will be limited to 1 year only which is previous year to the current year.&nbsp;&nbsp;</P><P>I want to have the chart for multi year, which the current year shows the previous year YTD figure, then I can apply current year minus previous year to get the YOY difference.&nbsp;&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Newbie7_0-1624966301891.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57701iBF7AB984FAFAABB5/image-size/large?v=v2&amp;px=999" role="button" title="Newbie7_0-1624966301891.png" alt="Newbie7_0-1624966301891.png" /></span></P><P>I'd greatly appreciate if someone can let me know how to write multi year previous year set expression.&nbsp;&nbsp;</P><P>Thank you for your help.</P> Tue, 29 Jun 2021 11:34:17 GMT Newbie777 2021-06-29T11:34:17Z https://community.qlik.com/t5/App-Development/Previous-Year-set/m-p/1818521#M67080 <P>Hello,</P><P>I'd like to write a set sum expression where the chart always shows 1 year previous to the selected year.&nbsp; I want to have the multi year chart so the expression below does not work&nbsp;</P><P>Sum({$&lt;[Date-Posting Date.autoCalendar.Year] = {$(=Year(Today())-1)}&gt;}[Expenses])</P><P>where the chart will be limited to 1 year only which is previous year to the current year.&nbsp;&nbsp;</P><P>I want to have the chart for multi year, which the current year shows the previous year YTD figure, then I can apply current year minus previous year to get the YOY difference.&nbsp;&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Newbie7_0-1624966301891.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57701iBF7AB984FAFAABB5/image-size/large?v=v2&amp;px=999" role="button" title="Newbie7_0-1624966301891.png" alt="Newbie7_0-1624966301891.png" /></span></P><P>I'd greatly appreciate if someone can let me know how to write multi year previous year set expression.&nbsp;&nbsp;</P><P>Thank you for your help.</P> Tue, 29 Jun 2021 11:34:17 GMT https://community.qlik.com/t5/App-Development/Previous-Year-set/m-p/1818521#M67080 Newbie777 2021-06-29T11:34:17Z