If then question

[SI_NY02]

I'm relatively new to Qlik and am looking for a way to write this formula

Active customers are defined as customers with Approved status who made a purchase in the same year/mo as when they opened the account.  I've written the below, but it doesn't seem to work.

if({<appl_status={'Approved'}>},(Count({<appl_status={'Approved'}>},{<customer_id = {"=[tran_date.autoCalendar.YearMonth]=[DateOpened.autoCalendar.YearMonth]"}>} distinct customer_id))

[BrunPierre · Accepted solution]

Maybe like this.

Count({<appl_status={'Approved'}, customer_id = {"=[tran_date.autoCalendar.YearMonth]=[DateOpened.autoCalendar.YearMonth]"}>} DISTINCT customer_id)

[vinieme12]

=count({<appl_status={'Approved'}>}  Distinct   

Aggr (  if(min([tran_date.autoCalendar.YearMonth])=min([DateOpened.autoCalendar.YearMonth]) , customer_id)   , customer_id))