topic Re: How would you convert expression to set analysis? in QlikView https://community.qlik.com/t5/QlikView/How-would-you-convert-expression-to-set-analysis/m-p/37978#M769912 <HTML><HEAD></HEAD><BODY><P>Or this</P><P></P><P><STRONG>=Count(DISTINCT {&lt;Date1, Date2 = {"$(='&gt;=' &amp; Date(Today() + 7))"}&gt;} iProductID)</STRONG></P></BODY></HTML> Thu, 31 May 2018 15:35:34 GMT sunny_talwar 2018-05-31T15:35:34Z How would you convert expression to set analysis? https://community.qlik.com/t5/QlikView/How-would-you-convert-expression-to-set-analysis/m-p/37976#M769910 <HTML><HEAD></HEAD><BODY><P>Hi Community, </P><P></P><P>How would you convert underlying expression to set analysis?</P><P></P><P>=count(distinct if(Date2 - Today()&gt;=7, ProductID, Null())) and ignore field name Date1=&nbsp;&nbsp;&nbsp; ??</P><P></P><P>Date1 = even if this field is being filter, it will have no effect on the formula. </P><P></P><P></P><P>Thanks in advance.&nbsp; </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-would-you-convert-expression-to-set-analysis/m-p/37976#M769910 mrichman 2020-11-25T16:16:04Z Re: How would you convert expression to set analysis? https://community.qlik.com/t5/QlikView/How-would-you-convert-expression-to-set-analysis/m-p/37977#M769911 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try with:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=count(distinct {&lt;Date1&gt;} if(Date2 - Today()&gt;=7, ProductID, Null())) </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Saludos<BR /></SPAN></P></BODY></HTML> Thu, 31 May 2018 14:40:07 GMT https://community.qlik.com/t5/QlikView/How-would-you-convert-expression-to-set-analysis/m-p/37977#M769911 fvelascog72 2018-05-31T14:40:07Z Re: How would you convert expression to set analysis? https://community.qlik.com/t5/QlikView/How-would-you-convert-expression-to-set-analysis/m-p/37978#M769912 <HTML><HEAD></HEAD><BODY><P>Or this</P><P></P><P><STRONG>=Count(DISTINCT {&lt;Date1, Date2 = {"$(='&gt;=' &amp; Date(Today() + 7))"}&gt;} iProductID)</STRONG></P></BODY></HTML> Thu, 31 May 2018 15:35:34 GMT https://community.qlik.com/t5/QlikView/How-would-you-convert-expression-to-set-analysis/m-p/37978#M769912 sunny_talwar 2018-05-31T15:35:34Z Re: How would you convert expression to set analysis? https://community.qlik.com/t5/QlikView/How-would-you-convert-expression-to-set-analysis/m-p/37979#M769913 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny!</P></BODY></HTML> Fri, 01 Jun 2018 08:16:01 GMT https://community.qlik.com/t5/QlikView/How-would-you-convert-expression-to-set-analysis/m-p/37979#M769913 mrichman 2018-06-01T08:16:01Z Re: How would you convert expression to set analysis? https://community.qlik.com/t5/QlikView/How-would-you-convert-expression-to-set-analysis/m-p/37980#M769914 <HTML><HEAD></HEAD><BODY><P>Thanks Federico</P></BODY></HTML> Fri, 01 Jun 2018 08:16:09 GMT https://community.qlik.com/t5/QlikView/How-would-you-convert-expression-to-set-analysis/m-p/37980#M769914 mrichman 2018-06-01T08:16:09Z