Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert if to Set Analysis

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.

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

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)

View solution in original post

2 Replies
settu_periasamy
Master III
Master III

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)

Not applicable
Author

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