https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/2154373#M1225079 <P>Sum({&lt;CalenderMonth={'$(vMaxMonth)'} , CalenderYear={'$(vMaxYear)'},OrderDate&gt;}Sales)</P> <P><BR />I'm trying calculate Sum of sales For The Month(FTM). Here I am trying to bypass OrderDate but it's not bypassing the order date.<BR /><BR /></P> <P>Please can someone suggest a solution</P> <P>Thanks and Regards</P> Tue, 19 Dec 2023 07:01:19 GMT IRT_Ankit 2023-12-19T07:01:19Z https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/2154373#M1225079 <P>Sum({&lt;CalenderMonth={'$(vMaxMonth)'} , CalenderYear={'$(vMaxYear)'},OrderDate&gt;}Sales)</P> <P><BR />I'm trying calculate Sum of sales For The Month(FTM). Here I am trying to bypass OrderDate but it's not bypassing the order date.<BR /><BR /></P> <P>Please can someone suggest a solution</P> <P>Thanks and Regards</P> Tue, 19 Dec 2023 07:01:19 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/2154373#M1225079 IRT_Ankit 2023-12-19T07:01:19Z https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/2154377#M1225080 <P>That is possibly because, your variable definitions are coming into play. You have to bypass the same date selection in those definitions as well.&nbsp;</P> Tue, 19 Dec 2023 07:06:51 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/2154377#M1225080 tresB 2023-12-19T07:06:51Z