topic Re: Count distinct in QlikView https://community.qlik.com/t5/QlikView/Count-distinct/m-p/1259818#M846903 <HTML><HEAD></HEAD><BODY><P>Ah, I wasn't using the parenthesis correctly...</P><P></P><P>Thank you!!</P></BODY></HTML> Wed, 22 Mar 2017 17:00:47 GMT 2017-03-22T17:00:47Z Count distinct https://community.qlik.com/t5/QlikView/Count-distinct/m-p/1259815#M846897 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I'm new to Qlikview. I have loaded all the data, but want to create a chart that gives me the average of the Totals of Y1, Y2 and Y3.</P><P></P><P>In this sample I would need to have the sum of everything divided by 3.</P><P></P><TABLE border="1" class="jiveBorder" height="199" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 233px; height: 193.63px;"><TBODY><TR><TH style="padding: 2px; text-align: center; color: rgb(255, 255, 255); background-color: rgb(102, 144, 188);" valign="middle"><STRONG>Serial Numbers</STRONG></TH><TH style="padding: 2px; text-align: center; color: rgb(255, 255, 255); background-color: rgb(102, 144, 188);" valign="middle"><STRONG>X1</STRONG></TH><TH style="padding: 2px; text-align: center; color: rgb(255, 255, 255); background-color: rgb(102, 144, 188);" valign="middle"><STRONG>X2</STRONG></TH></TR><TR><TD style="padding: 2px; text-align: center;"><P>Y1</P></TD><TD style="padding: 2px; text-align: center;">1.2</TD><TD style="padding: 2px; text-align: center;">5.1</TD></TR><TR><TD style="padding: 2px; text-align: center;">Y1</TD><TD style="padding: 2px; text-align: center;">5.1</TD><TD style="padding: 2px; text-align: center;">2.6</TD></TR><TR><TD style="padding: 2px; text-align: center;">Y1</TD><TD style="padding: 2px; text-align: center;">4.2</TD><TD style="padding: 2px; text-align: center;">6.5</TD></TR><TR><TD style="padding: 2px; text-align: center;">Y2</TD><TD style="padding: 2px; text-align: center;">6.9</TD><TD style="padding: 2px; text-align: center;">3.3</TD></TR><TR><TD style="padding: 2px; text-align: center;">Y2</TD><TD style="padding: 2px; text-align: center;">2.1</TD><TD style="padding: 2px; text-align: center;">3.7</TD></TR><TR><TD style="padding: 2px; text-align: center;">Y2</TD><TD style="padding: 2px; text-align: center;">7.4</TD><TD style="padding: 2px; text-align: center;">8.4</TD></TR><TR><TD style="padding: 2px; text-align: center;">Y3</TD><TD style="padding: 2px; text-align: center;">5.8</TD><TD style="padding: 2px; text-align: center;">8.6</TD></TR></TBODY></TABLE><P></P><P></P><P>I tried to do this<SPAN style="font-size: 10pt;"> +<SPAN style="color: #0000ff;">sum</SPAN>(x1)/<SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #0000ff;">[DISTINCT]</SPAN><SPAN style="color: #800000;">[Serial Numers]</SPAN></SPAN><SPAN style="font-size: 10pt;">)&nbsp; but it's not working.</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Do you know how to use count discriminating the equal values?</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Thank you!</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Victor</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Count-distinct/m-p/1259815#M846897 2020-11-25T16:16:04Z Re: Count distinct https://community.qlik.com/t5/QlikView/Count-distinct/m-p/1259816#M846899 <HTML><HEAD></HEAD><BODY><P>The expression should have worked... I am getting 10.9 with the above expression</P><P>or you can try this</P><P><STRONG>=Avg(Aggr(Sum(X1), [Serial Numbers]))</STRONG></P></BODY></HTML> Wed, 22 Mar 2017 15:36:18 GMT https://community.qlik.com/t5/QlikView/Count-distinct/m-p/1259816#M846899 sunny_talwar 2017-03-22T15:36:18Z Re: Count distinct https://community.qlik.com/t5/QlikView/Count-distinct/m-p/1259817#M846901 <HTML><HEAD></HEAD><BODY><P>What are you expecting from given data?</P></BODY></HTML> Wed, 22 Mar 2017 15:38:17 GMT https://community.qlik.com/t5/QlikView/Count-distinct/m-p/1259817#M846901 Anil_Babu_Samineni 2017-03-22T15:38:17Z Re: Count distinct https://community.qlik.com/t5/QlikView/Count-distinct/m-p/1259818#M846903 <HTML><HEAD></HEAD><BODY><P>Ah, I wasn't using the parenthesis correctly...</P><P></P><P>Thank you!!</P></BODY></HTML> Wed, 22 Mar 2017 17:00:47 GMT https://community.qlik.com/t5/QlikView/Count-distinct/m-p/1259818#M846903 2017-03-22T17:00:47Z Re: Count distinct https://community.qlik.com/t5/QlikView/Count-distinct/m-p/1259819#M846905 <HTML><HEAD></HEAD><BODY><P>Right, the square brackets around TOTAL (as shown e.g. in some HELP texts) is only saying that's an optional part of the function, not that it should be printed:</P><P></P><P><A href="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/Backus-Naur-formalism.htm?_ga=1.99757918.1323026264.1469693381" title="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/Backus-Naur-formalism.htm?_ga=1.99757918.1323026264.1469693381">What is Backus-Naur formalism? ‒ QlikView</A></P><P></P><P>Easy to get it wrong...</P></BODY></HTML> Wed, 22 Mar 2017 17:34:47 GMT https://community.qlik.com/t5/QlikView/Count-distinct/m-p/1259819#M846905 swuehl 2017-03-22T17:34:47Z