https://community.qlik.com/t5/QlikView/How-do-I-convert-this-expression-using-Set-Analysis-adding-in-a/m-p/1594330#M456598 <P>I have the following expression I would like to convert to Set Analysis and add a condition:</P><P>=(Sum([Budget])/Count([Budget]))</P><P>I need to add a condition for Year.&nbsp; The condition would be for current year which I have a variable for.</P><P>vFY is the name of the variable. So, Year=vFY</P><P>How can I convert this to Set Analysis and add this condition?</P> Sat, 16 Nov 2024 03:13:37 GMT cliff_clayman 2024-11-16T03:13:37Z https://community.qlik.com/t5/QlikView/How-do-I-convert-this-expression-using-Set-Analysis-adding-in-a/m-p/1594330#M456598 <P>I have the following expression I would like to convert to Set Analysis and add a condition:</P><P>=(Sum([Budget])/Count([Budget]))</P><P>I need to add a condition for Year.&nbsp; The condition would be for current year which I have a variable for.</P><P>vFY is the name of the variable. So, Year=vFY</P><P>How can I convert this to Set Analysis and add this condition?</P> Sat, 16 Nov 2024 03:13:37 GMT https://community.qlik.com/t5/QlikView/How-do-I-convert-this-expression-using-Set-Analysis-adding-in-a/m-p/1594330#M456598 cliff_clayman 2024-11-16T03:13:37Z https://community.qlik.com/t5/QlikView/How-do-I-convert-this-expression-using-Set-Analysis-adding-in-a/m-p/1594334#M456599 <P><SPAN>=(Sum({$&lt;Year={'$(=$(vFY))'}&gt;}[Budget])/Count([Budget]))</SPAN></P> Thu, 20 Jun 2019 20:15:20 GMT https://community.qlik.com/t5/QlikView/How-do-I-convert-this-expression-using-Set-Analysis-adding-in-a/m-p/1594334#M456599 jwjackso 2019-06-20T20:15:20Z