join table with if

[new020]

Hi,

i don´t what i´m doing wrong but i need to know if is possible to add if(..) when we join a table as i show below,

----

left join Load

"Month",
level,

if(("top25_cust_pay"='1'),(Sum( "Paying Customer_12")/sum(Active_Customer_Total)),0) as Top25_National_PayingCustomer

resident [LanguageList-3-9] group By "Month",level;

----

[edwin]

in general yes, just make sure you are using correct syntax 

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/combine-tables...

the load statement can be an aggregation, make sure all dimensions that arent aggregated are in the group by (including the field in the if statement)