Case statement in Qlik

[Kaushik2020]

I have below SQL statement which I am looking for an alternative in qlik sense. 

count(distinct (case when (new_exist_flag='New' and (act_date between trunc(current_date-12,'MM') and current_date-12)) then co_id else null end))

I can use the count and distinct as part of Set expression from the UI. 

so here i want to see a conversion of SQL statement - case when (new_exist_flag='New' and (act_date between trunc(current_date-12,'MM') and current_date-12)) then co_id else null end

-> columns from table:

new_exist_flag, act_date, co_id

thanks in advance

[Chanty4u · Accepted solution]

Try something like this

=count({<new_exist_flag={'New'}, act_date={">=$(=AddMonths(date(Today(), 'MM'), -12))<$(=date(Today(), 'MM'))"}>} DISTINCT co_id)

[Kaushik2020]

thanks for the reply. it worked with a small change. 

~ Below shows previous month count. how we can modify this to qlik sense ? 

count(distinct (case when ( (act_date between add_months(trunc(current_date-1,'MM'),-1) and add_months((current_date-1),-1))) then co_id else null end)) ,