convert if to set analysis

[#1]

hi,

I need to convert my expressions based on if-condition:

=Count(DISTINCT if(Oppo_CreatedDate>= MonthStart([Datedopportunite]) and Oppo_CreatedDate<= MonthEnd([Datedopportunite])and IsNull(Oppo_Closed) , OpportunityCD))

=Count(DISTINCT if(Oppo_CreatedDate>= MonthStart([Datedopportunite]) and Oppo_CreatedDate<= MonthEnd([Datedopportunite])

and IsNull(Oppo_Closed) , OpportunityCD))

To a set analysis !!!

thanks

[#2]

Hi Hilal,

Try the below expression:

=count({<Oppo_CreatedDate = {">= $(=MonthStart(Datedopportunite)) <= $(=MonthEnd(Datedopportunite))"}, Oppo_Closed = {''}>} OpportunityCD)

[MayilVahanan]

Hi

Try like this

=count({<Oppo_CreatedDate = {">= $(=MonthStart(Datedopportunite)) <= $(=MonthEnd(Datedopportunite))"}, Oppo_Closed -= {'*'}>} Distinct OpportunityCD)

[danielact]

Try this:

=Count(DISTINCT {$<Oppo_CreatedDate={'=Oppo_CreatedDate>= MonthStart([Datedopportunite]) and Oppo_CreatedDate<= MonthEnd([Datedopportunite])'}, Oppo_Closed={'=IsNull(Oppo_Closed)'}>} OpportunityCD)

[#5]

thanks for solutions but no one of these set analysis work, they return 0

[danielact]

Can you post a qvw so we can take a look at the dataset?