topic Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1298027#M404923 <HTML><HEAD></HEAD><BODY><P>Hello community,</P><P>I have a problem on QlikView.</P><P>I work on a QlikView project, I found this expression in a chart :</P><P></P><P>count({&lt;[Categorie_Client]={'A'}&gt;}[Categorie_Client]) /count(TOTAL<STRONG style="font-size: 12pt;"> <SPAN style="font-size: 10pt;">&lt;moisannee&gt;</SPAN></STRONG> [Categorie_Client])</P><P></P><P><SPAN lang="en">With as dimmension moisannee (as values : Jan. 2017, Fev.2017, Mars2017 ...) </SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">My questions are:</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; - What does the expression&nbsp; &lt;moisannées&gt;&nbsp; mean ( in&nbsp; count(TOTAL<STRONG style="font-size: 12pt;"> <SPAN style="font-size: 10pt;">&lt;moisannee&gt;</SPAN></STRONG> [Categorie_Client])) ? what is this doing?</P><P>&nbsp;&nbsp;&nbsp;&nbsp; - What is the equivalence of this expression in Set Analysis? (count(TOTAL<STRONG style="font-size: 12pt;"> <SPAN style="font-size: 10pt;">&lt;moisannee&gt;</SPAN></STRONG> [Categorie_Client]))</P><P></P><P>Any idea?</P><P></P><P>Thanks in advance.</P><P></P><P>Tsiry.</P></BODY></HTML> Tue, 11 Apr 2017 10:42:39 GMT harson 2017-04-11T10:42:39Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1298027#M404923 <HTML><HEAD></HEAD><BODY><P>Hello community,</P><P>I have a problem on QlikView.</P><P>I work on a QlikView project, I found this expression in a chart :</P><P></P><P>count({&lt;[Categorie_Client]={'A'}&gt;}[Categorie_Client]) /count(TOTAL<STRONG style="font-size: 12pt;"> <SPAN style="font-size: 10pt;">&lt;moisannee&gt;</SPAN></STRONG> [Categorie_Client])</P><P></P><P><SPAN lang="en">With as dimmension moisannee (as values : Jan. 2017, Fev.2017, Mars2017 ...) </SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P><SPAN lang="en">My questions are:</SPAN></P><P><SPAN lang="en"><BR /></SPAN></P><P>&nbsp;&nbsp;&nbsp;&nbsp; - What does the expression&nbsp; &lt;moisannées&gt;&nbsp; mean ( in&nbsp; count(TOTAL<STRONG style="font-size: 12pt;"> <SPAN style="font-size: 10pt;">&lt;moisannee&gt;</SPAN></STRONG> [Categorie_Client])) ? what is this doing?</P><P>&nbsp;&nbsp;&nbsp;&nbsp; - What is the equivalence of this expression in Set Analysis? (count(TOTAL<STRONG style="font-size: 12pt;"> <SPAN style="font-size: 10pt;">&lt;moisannee&gt;</SPAN></STRONG> [Categorie_Client]))</P><P></P><P>Any idea?</P><P></P><P>Thanks in advance.</P><P></P><P>Tsiry.</P></BODY></HTML> Tue, 11 Apr 2017 10:42:39 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1298027#M404923 harson 2017-04-11T10:42:39Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1298028#M404924 <HTML><HEAD></HEAD><BODY><P>check this</P><P></P><P><A href="https://community.qlikview.com/thread/54668" title="https://community.qlikview.com/thread/54668">a simple question: count(total distinct value)? | Qlik Community</A></P><P></P><P><A href="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/CounterAggregationFunctions/count.htm" title="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/CounterAggregationFunctions/count.htm">Count - chart function ‒ QlikView</A></P></BODY></HTML> Tue, 11 Apr 2017 10:46:44 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/1298028#M404924 settu_periasamy 2017-04-11T10:46:44Z