topic Re: join table with if in App Development

join table with if

new020 — Thu, 19 Nov 2020 14:48:46 GMT

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;

----

Re: join table with if

edwin — Thu, 19 Nov 2020 15:33:21 GMT

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-join-keep.htm

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)