Convert if to Set Analysis

[#1]

Hello. I have a following If statement in calculated dimension. Is it possible to convert it to Set Analysis?

=Aggr(  If(Min(R_Create_Date) <='$(vMaxClntAddDate)' And (R_Purged_Flag = 'NO' OR Max(R_Purged_Date) >= '$(vMinClntPurgeDate)'),  Customer_Group_Name),    Customer_Group_Name)

Thank you.

[settu_periasamy · Accepted solution]

Hi,

Try something like,

=Aggr(Only({<R_Create_Date={"$(=Min(R_Create_Date))<=$(vMaxClntAddDate)"},R_Purged_Flag = {'NO'}>+<R_Purged_Date={"$(=Max(R_Purged_Date))<=$(vMinClntPurgeDate)"}>}Customer_Group_Name),Customer_Group_Name)

[#3]

Thank you Settu. I guess I over complicated it. For some reason I assumed there would be a lot of P().