Expression not working

[TomBond77]

Hi experts

I am filtering on Calendar.Year = 2022.

The result should show 12.2021 - 06.2022. But the expression is not working as expected. Any solution from your side?

if([Account]= '3000' 
Sum({< [Calendar.Year]=, [Calendar.Month]=, 
%Date={">=$(=MonthStart(Max(%Date), -13))<='01.06.2022'"}>} $(='Fact.AMOUNT_'&'_Amount')))

[MartW]

from the looks of it you are missing the comma to end the check and go to the True and after the False.

if([Account]= '3000' 
Sum({< [Calendar.Year]=, [Calendar.Month]=, 
%Date={">=$(=MonthStart(Max(%Date), -13))<='01.06.2022'"}>} $(='Fact.AMOUNT_'&'_Amount')))

you can do something like this:
if([Account]= '3000',
//True: 
   Sum({< [Calendar.Year]=, [Calendar.Month]=, %Date={">=$(=MonthStart(Max(%Date), -13))<='01.06.2022'"}>} $(='Fact.AMOUNT_'&'_Amount')),
//False
'False Statement'
)

 https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFun...