topic Statement conversion: SQL to Qlik conversion in App Development https://community.qlik.com/t5/App-Development/Statement-conversion-SQL-to-Qlik-conversion/m-p/2081648#M88715 <P>is it possible to write below SQL statement to a Qlik Set expression ?&nbsp;</P> <P>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</P> Thu, 08 Jun 2023 11:53:48 GMT Kaushik2020 2023-06-08T11:53:48Z Statement conversion: SQL to Qlik conversion https://community.qlik.com/t5/App-Development/Statement-conversion-SQL-to-Qlik-conversion/m-p/2081648#M88715 <P>is it possible to write below SQL statement to a Qlik Set expression ?&nbsp;</P> <P>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</P> Thu, 08 Jun 2023 11:53:48 GMT https://community.qlik.com/t5/App-Development/Statement-conversion-SQL-to-Qlik-conversion/m-p/2081648#M88715 Kaushik2020 2023-06-08T11:53:48Z