topic Re: Convert if to Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Convert-if-to-Set-Analysis/m-p/1294355#M828847 <HTML><HEAD></HEAD><BODY><P>Thank you Settu. I guess I over complicated it. For some reason I assumed there would be a lot of P().</P></BODY></HTML> Thu, 29 Jun 2017 15:31:18 GMT 2017-06-29T15:31:18Z Convert if to Set Analysis https://community.qlik.com/t5/QlikView/Convert-if-to-Set-Analysis/m-p/1294353#M828845 <HTML><HEAD></HEAD><BODY><P>Hello. I have a following If statement in calculated dimension. Is it possible to convert it to Set Analysis?</P><P></P><P>=Aggr(&nbsp; If(Min(R_Create_Date) &lt;='$(vMaxClntAddDate)' And (R_Purged_Flag = 'NO' OR Max(R_Purged_Date) &gt;= '$(vMinClntPurgeDate)'),&nbsp; Customer_Group_Name),&nbsp;&nbsp;&nbsp; Customer_Group_Name)</P><P></P><P>Thank you.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Convert-if-to-Set-Analysis/m-p/1294353#M828845 2020-11-25T16:16:04Z Re: Convert if to Set Analysis https://community.qlik.com/t5/QlikView/Convert-if-to-Set-Analysis/m-p/1294354#M828846 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try something like,</P><P></P><P><STRONG><EM>=Aggr(Only({&lt;R_Create_Date={"$(=Min(R_Create_Date))&lt;=$(vMaxClntAddDate)"},R_Purged_Flag = {'NO'}&gt;+&lt;R_Purged_Date={"$(=Max(R_Purged_Date))&lt;=$(vMinClntPurgeDate)"}&gt;}Customer_Group_Name),Customer_Group_Name)</EM></STRONG></P></BODY></HTML> Thu, 29 Jun 2017 04:58:25 GMT https://community.qlik.com/t5/QlikView/Convert-if-to-Set-Analysis/m-p/1294354#M828846 settu_periasamy 2017-06-29T04:58:25Z Re: Convert if to Set Analysis https://community.qlik.com/t5/QlikView/Convert-if-to-Set-Analysis/m-p/1294355#M828847 <HTML><HEAD></HEAD><BODY><P>Thank you Settu. I guess I over complicated it. For some reason I assumed there would be a lot of P().</P></BODY></HTML> Thu, 29 Jun 2017 15:31:18 GMT https://community.qlik.com/t5/QlikView/Convert-if-to-Set-Analysis/m-p/1294355#M828847 2017-06-29T15:31:18Z