Statement conversion: SQL to Qlik conversion

[Kaushik2020]

is it possible to write below SQL statement to a Qlik Set expression ? 

count(distinct (case when (new_exist_flag='New' and (activation_date between trunc(current_date-1,'MM') and current_date-1)) then con_id else null end)) New