topic Re: Count and % in QlikView https://community.qlik.com/t5/QlikView/Count-and/m-p/325001#M119718 <HTML><HEAD></HEAD><BODY><P>I think this?</P><P></P><P><SPAN style="font-family: courier new,courier;">=count({&lt;DateType={'Agendada'}&gt;}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Remision.numrem)</SPAN><BR /><SPAN style="font-family: courier new,courier;">/count({&lt;DateType={'Agendada'}&gt;} total &lt;Medico&gt; Remision.numrem)</SPAN></P></BODY></HTML> Wed, 16 Nov 2011 20:36:26 GMT johnw 2011-11-16T20:36:26Z Count and % https://community.qlik.com/t5/QlikView/Count-and/m-p/325000#M119717 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have this expression:</P><P></P><P style="text-align: left;">&nbsp;&nbsp;&nbsp;&nbsp; Count({$&lt;DateType={Agendada}&gt;}Remision.numrem)</P><P></P><P style="text-align: left;">And I have this Pivot Table</P><P></P><P></P><P></P><P style="text-align: left;"><IMG alt="Pivot Table.png" class="jive-image-thumbnail jive-image" height="216" onclick="" src="https://community.qlik.com/legacyfs/online/8666_Pivot+Table.png" width="721" /></P><P> The column called "Contador" is the one that contains the expression... now... in a new colum I want to get a percentage of each single row of "ServicioC" compared to the total of each row of column "Medico"</P><P></P><P>How can I do that? Is kind of confusing for me.</P><P></P><P>Thanks a lot!</P></BODY></HTML> Wed, 16 Nov 2011 20:27:58 GMT https://community.qlik.com/t5/QlikView/Count-and/m-p/325000#M119717 Anonymous 2011-11-16T20:27:58Z Re: Count and % https://community.qlik.com/t5/QlikView/Count-and/m-p/325001#M119718 <HTML><HEAD></HEAD><BODY><P>I think this?</P><P></P><P><SPAN style="font-family: courier new,courier;">=count({&lt;DateType={'Agendada'}&gt;}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Remision.numrem)</SPAN><BR /><SPAN style="font-family: courier new,courier;">/count({&lt;DateType={'Agendada'}&gt;} total &lt;Medico&gt; Remision.numrem)</SPAN></P></BODY></HTML> Wed, 16 Nov 2011 20:36:26 GMT https://community.qlik.com/t5/QlikView/Count-and/m-p/325001#M119718 johnw 2011-11-16T20:36:26Z