If statements and variables expression used in script load editor ?

[Domino1]

 Hello,

Here is my expression on a table.  How to rewrite so it is calculated on load editor instead ?

 vFY = 2023 

 MonthNum1 = 09

If(Sum({<[Fiscal Year]={'$(vFY)'},$(s_MonthNum1)>} Sales  ) > 0, '',

If(Sum({<[Fiscal Year]={'$(vFY0)'},$(s_MonthNum1)>}Order )

/Sum({<[Fiscal Year]={'$(vFY0)'},$(s_MonthNum1)>} Equipment ) >= .8, 'FY'&Right($(vFY0),2),  '    '))  

[Or]

Generally speaking, replace your set analysis with Where conditions in the load script - Where Fiscal Year = 2023 and Month = 09. If() and sum() syntax otherwise stays the same. You may need to add a Group By by whatever dimensions you're using on the front end.

[Domino1]

....

[Or]

https://community.qlik.com/t5/New-to-Qlik-Sense/If-statements-and-variables-expression-used-in-scrip...