topic how to convert into set analysis expression in QlikView https://community.qlik.com/t5/QlikView/how-to-convert-into-set-analysis-expression/m-p/1308732#M830665 <HTML><HEAD></HEAD><BODY><P>hi all </P><P></P><P>how to convert below if condition&nbsp; into set analysis expression</P><P></P><P>count(DISTINCT if(Status='Pending' and YearEndFlag='Y' and KPI_Flag='RF' and (TimeSpecial_1=0 or DueDate&lt;Date),JobID))</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT vengadeshpalani 2020-11-25T16:16:04Z how to convert into set analysis expression https://community.qlik.com/t5/QlikView/how-to-convert-into-set-analysis-expression/m-p/1308732#M830665 <HTML><HEAD></HEAD><BODY><P>hi all </P><P></P><P>how to convert below if condition&nbsp; into set analysis expression</P><P></P><P>count(DISTINCT if(Status='Pending' and YearEndFlag='Y' and KPI_Flag='RF' and (TimeSpecial_1=0 or DueDate&lt;Date),JobID))</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-convert-into-set-analysis-expression/m-p/1308732#M830665 vengadeshpalani 2020-11-25T16:16:04Z Re: how to convert into set analysis expression https://community.qlik.com/t5/QlikView/how-to-convert-into-set-analysis-expression/m-p/1308733#M830666 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P>= count(DISTINCT {&lt; Status = {'Pending'}, YearEndFlag = {'Y'}, KPI_Flag= {'RF'} &gt;} IF(TimeSpecial_1=0 OR DueDate &lt; Date, JobID))</P></BODY></HTML> Sun, 18 Jun 2017 02:26:58 GMT https://community.qlik.com/t5/QlikView/how-to-convert-into-set-analysis-expression/m-p/1308733#M830666 vishsaggi 2017-06-18T02:26:58Z