topic % calculation in QlikView https://community.qlik.com/t5/QlikView/calculation/m-p/346297#M128121 <HTML><HEAD></HEAD><BODY><P> Thanks you so much!</P></BODY></HTML> Thu, 10 May 2012 18:12:02 GMT 2012-05-10T18:12:02Z % calculation https://community.qlik.com/t5/QlikView/calculation/m-p/346295#M128119 <HTML><HEAD></HEAD><BODY><P>Hi-Can anyone please let me know what can be done to get this % calculation.</P><P>&nbsp;&nbsp; </P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 40%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>State</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Count of Call</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>%</STRONG></SPAN></TH></TR><TR><TD>AZ</TD><TD>100</TD><TD>6.7%</TD></TR><TR><TD>CA</TD><TD>300</TD><TD>20%</TD></TR><TR><TD>VA</TD><TD>500</TD><TD>33.3%</TD></TR><TR><TD>TX</TD><TD>600</TD><TD>40%</TD></TR><TR><TD>Total</TD><TD>1500</TD><TD>100%</TD></TR></TBODY></TABLE><P></P><P>Count of call is calculated thru a set analysis.<BR /><SPAN style="color: #0000ff; font-size: 12pt;">count(DISTINCT {$ &lt; Type={'TEL'} &gt; }call)</SPAN></P><P><SPAN style="color: #0000ff; font-size: 12pt;"> </SPAN></P><P><SPAN style="color: #000000; font-size: 10pt;">I am not sure how can the partial sum which is 1500 in the above example can be achieved?</SPAN></P></BODY></HTML> Thu, 10 May 2012 17:03:29 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/346295#M128119 2012-05-10T17:03:29Z % calculation https://community.qlik.com/t5/QlikView/calculation/m-p/346296#M128120 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #0000ff; font-family: Arial; font-size: 16px; background-color: #eef4f9;">count(DISTINCT {$ &lt; Type={'TEL'} &gt; }call)/<SPAN style="color: #0000ff; font-family: Arial; font-size: 16px; background-color: #eef4f9;">count(DISTINCT TOTAL{$ &lt; Type={'TEL'} &gt; }call)</SPAN></SPAN></P><P></P><P><SPAN style="color: #0000ff; font-size: 16px; background-color: #eef4f9; font-family: Arial;">¿?<BR /></SPAN></P></BODY></HTML> Thu, 10 May 2012 17:14:19 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/346296#M128120 2012-05-10T17:14:19Z % calculation https://community.qlik.com/t5/QlikView/calculation/m-p/346297#M128121 <HTML><HEAD></HEAD><BODY><P> Thanks you so much!</P></BODY></HTML> Thu, 10 May 2012 18:12:02 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/346297#M128121 2012-05-10T18:12:02Z