topic Re: Function count & sum in set analysis in QlikView https://community.qlik.com/t5/QlikView/Function-count-sum-in-set-analysis/m-p/777170#M1021243 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to count distinct clients (from my favorite) that have a turnover (CA NET) &gt; to 700€. The [CODE SOUS-SOUS FAMILLE]={7200,7280} is just a sub category of my favorite.</P><P></P><P>My expression doesn't work..</P><P></P><P>Regards</P></BODY></HTML> Tue, 24 Mar 2015 11:12:20 GMT 2015-03-24T11:12:20Z Function count & sum in set analysis https://community.qlik.com/t5/QlikView/Function-count-sum-in-set-analysis/m-p/777168#M1021240 <HTML><HEAD></HEAD><BODY><P>Hello everyone, </P><P></P><P>I've got a problem with this expression:</P><P></P><P>=count(distinct {$*Nondirectifsfrancebrosserie&lt;[CA NET]={"${=sum([CA NET])}&gt;700"},[CODE SOUS-SOUS FAMILLE]={7200,7280}&gt;} [COUNT CLIENT])</P><P></P><P><SPAN style="text-decoration: underline;">Where</SPAN> :</P><P><SPAN style="font-size: 13.3333330154419px;">Nondirectifsfrancebrosserie is my favorite</SPAN></P><P><SPAN style="font-size: 13.3333330154419px; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Can someone help me ?</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Thanks a lot,</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">BI<BR /></SPAN></P></BODY></HTML> Tue, 24 Mar 2015 10:00:01 GMT https://community.qlik.com/t5/QlikView/Function-count-sum-in-set-analysis/m-p/777168#M1021240 2015-03-24T10:00:01Z Re: Function count & sum in set analysis https://community.qlik.com/t5/QlikView/Function-count-sum-in-set-analysis/m-p/777169#M1021242 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>What are you trying to do??</P><P></P><P>Can explain in detail your requirement.</P><P></P><P>Regards</P></BODY></HTML> Tue, 24 Mar 2015 11:06:16 GMT https://community.qlik.com/t5/QlikView/Function-count-sum-in-set-analysis/m-p/777169#M1021242 PrashantSangle 2015-03-24T11:06:16Z Re: Function count & sum in set analysis https://community.qlik.com/t5/QlikView/Function-count-sum-in-set-analysis/m-p/777170#M1021243 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am trying to count distinct clients (from my favorite) that have a turnover (CA NET) &gt; to 700€. The [CODE SOUS-SOUS FAMILLE]={7200,7280} is just a sub category of my favorite.</P><P></P><P>My expression doesn't work..</P><P></P><P>Regards</P></BODY></HTML> Tue, 24 Mar 2015 11:12:20 GMT https://community.qlik.com/t5/QlikView/Function-count-sum-in-set-analysis/m-p/777170#M1021243 2015-03-24T11:12:20Z