https://community.qlik.com/t5/App-Development/Using-Year-Function-in-Set-Analysis/m-p/2462647#M98985 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/238934">@AJ2024</a>&nbsp;,</P> <P>Do you have a Year field based on the date in your datamodel?&nbsp;</P> <P>Then use</P> <UL> <LI><SPAN>=Sum({$&lt; Year</SPAN><SPAN>={2020} &gt;}[Measure])</SPAN></LI> </UL> <P>Based on a date DD-MM-YYYY you could use</P> <UL> <LI><SPAN>=Sum({$&lt; [Date Field]</SPAN><SPAN>={"*-2020"} &gt;}[Measure])</SPAN></LI> </UL> <DIV class="AddMessageTags lia-message-tags lia-component-message-view-widget-tags">It's better to create a Year field</DIV> <UL> <LI>Year(<SPAN>[Date Field]) AS Year</SPAN></LI> </UL> <P>&nbsp;</P> <P>Make it dynamic, select the max value of YEAR&nbsp;</P> <UL> <LI><SPAN>=Sum({$&lt; Year={"=$(=MAX(Year))"} &gt;}[Measure])</SPAN></LI> </UL> <P><SPAN>Last Year</SPAN></P> <UL> <LI><SPAN><SPAN>=Sum({$&lt; Year={"=$(=MAX(Year)-1)"} &gt;}[Measure])</SPAN></SPAN></LI> </UL> <DIV class="AddMessageTags lia-message-tags lia-component-message-view-widget-tags">&nbsp;</DIV> <P>&nbsp;</P> Fri, 14 Jun 2024 14:56:28 GMT p_verkooijen 2024-06-14T14:56:28Z https://community.qlik.com/t5/App-Development/Using-Year-Function-in-Set-Analysis/m-p/2462646#M98984 <P>Looking for help on syntax to use the Year function in set analysis. How do I need to modify the expression below to make it work?</P> <P>=Sum({$&lt;<U><STRONG>Year</STRONG></U>([Date Field])={2020}&gt;}[Measure])</P> Fri, 14 Jun 2024 14:51:16 GMT https://community.qlik.com/t5/App-Development/Using-Year-Function-in-Set-Analysis/m-p/2462646#M98984 AJ2024 2024-06-14T14:51:16Z https://community.qlik.com/t5/App-Development/Using-Year-Function-in-Set-Analysis/m-p/2462647#M98985 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/238934">@AJ2024</a>&nbsp;,</P> <P>Do you have a Year field based on the date in your datamodel?&nbsp;</P> <P>Then use</P> <UL> <LI><SPAN>=Sum({$&lt; Year</SPAN><SPAN>={2020} &gt;}[Measure])</SPAN></LI> </UL> <P>Based on a date DD-MM-YYYY you could use</P> <UL> <LI><SPAN>=Sum({$&lt; [Date Field]</SPAN><SPAN>={"*-2020"} &gt;}[Measure])</SPAN></LI> </UL> <DIV class="AddMessageTags lia-message-tags lia-component-message-view-widget-tags">It's better to create a Year field</DIV> <UL> <LI>Year(<SPAN>[Date Field]) AS Year</SPAN></LI> </UL> <P>&nbsp;</P> <P>Make it dynamic, select the max value of YEAR&nbsp;</P> <UL> <LI><SPAN>=Sum({$&lt; Year={"=$(=MAX(Year))"} &gt;}[Measure])</SPAN></LI> </UL> <P><SPAN>Last Year</SPAN></P> <UL> <LI><SPAN><SPAN>=Sum({$&lt; Year={"=$(=MAX(Year)-1)"} &gt;}[Measure])</SPAN></SPAN></LI> </UL> <DIV class="AddMessageTags lia-message-tags lia-component-message-view-widget-tags">&nbsp;</DIV> <P>&nbsp;</P> Fri, 14 Jun 2024 14:56:28 GMT https://community.qlik.com/t5/App-Development/Using-Year-Function-in-Set-Analysis/m-p/2462647#M98985 p_verkooijen 2024-06-14T14:56:28Z https://community.qlik.com/t5/App-Development/Using-Year-Function-in-Set-Analysis/m-p/2462649#M98986 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/28986">@p_verkooijen</a>,</P> <P>I don't have a year field in the data model currently but that sounds like the better solution. I'll go ahead and add it. Thanks!</P> Fri, 14 Jun 2024 15:00:26 GMT https://community.qlik.com/t5/App-Development/Using-Year-Function-in-Set-Analysis/m-p/2462649#M98986 AJ2024 2024-06-14T15:00:26Z