topic Re: Sum(Count(distinc(Serie))) in QlikView https://community.qlik.com/t5/QlikView/Sum-Count-distinc-Serie/m-p/577703#M1105634 <HTML><HEAD></HEAD><BODY><P>mmmm ok&nbsp; Gracias</P></BODY></HTML> Fri, 14 Mar 2014 16:42:23 GMT 2014-03-14T16:42:23Z Sum(Count(distinc(Serie))) https://community.qlik.com/t5/QlikView/Sum-Count-distinc-Serie/m-p/577699#M1105630 <HTML><HEAD></HEAD><BODY><P><BR />Buen dia&nbsp; nuevamente solicitando su ayuda</P><P></P><P>Tengo el siguiente calculo por scrip</P><P><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;"> (</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Distinct</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Serie</SPAN><SPAN style="font-size: 8pt;">) as Cuenta_serie</SPAN></P><P><SPAN style="font-size: 8pt;">y en una tabla </SPAN></P><P><SPAN style="font-size: 8pt;">Sum(</SPAN><SPAN style="color: #800000; font-size: 8pt;">Cuenta_Serie</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P><SPAN style="font-size: 8pt;">Estoy tratando de generar el dato en el scrip pero me da error</SPAN></P><P><SPAN style="font-size: 8pt;">Sum(count(distinct Serie) as Cuenta_Serie</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">Me podrian ayudar como debe quedar la formula para realizar un conteo y la suma de ese conteo x scrip,&nbsp; Gracias</SPAN></P><P></P><P></P><P></P><P></P></BODY></HTML> Fri, 14 Mar 2014 16:35:24 GMT https://community.qlik.com/t5/QlikView/Sum-Count-distinc-Serie/m-p/577699#M1105630 2014-03-14T16:35:24Z Re: Sum(Count(distinc(Serie))) https://community.qlik.com/t5/QlikView/Sum-Count-distinc-Serie/m-p/577700#M1105631 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 11px;">Sum(count(distinct Serie)) as Cuenta_Serie</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 11px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 11px;">there is not the last parenthesis )<BR /></SPAN></P></BODY></HTML> Fri, 14 Mar 2014 16:36:51 GMT https://community.qlik.com/t5/QlikView/Sum-Count-distinc-Serie/m-p/577700#M1105631 alexandros17 2014-03-14T16:36:51Z Re: Sum(Count(distinc(Serie))) https://community.qlik.com/t5/QlikView/Sum-Count-distinc-Serie/m-p/577701#M1105632 <HTML><HEAD></HEAD><BODY><P>You can't nest aggregation functions in the script. So use either sum(Serie) or count(distinct Serie). If you need the sum of the counts then you need to create a table with the counts first and then calculate the sums on that new table.</P></BODY></HTML> Fri, 14 Mar 2014 16:39:38 GMT https://community.qlik.com/t5/QlikView/Sum-Count-distinc-Serie/m-p/577701#M1105632 Gysbert_Wassenaar 2014-03-14T16:39:38Z Re: Sum(Count(distinc(Serie))) https://community.qlik.com/t5/QlikView/Sum-Count-distinc-Serie/m-p/577702#M1105633 <HTML><HEAD></HEAD><BODY><P>Si que pena se me fue ese parentesis ,&nbsp; pero el dato que me da es cero</P></BODY></HTML> Fri, 14 Mar 2014 16:39:53 GMT https://community.qlik.com/t5/QlikView/Sum-Count-distinc-Serie/m-p/577702#M1105633 2014-03-14T16:39:53Z Re: Sum(Count(distinc(Serie))) https://community.qlik.com/t5/QlikView/Sum-Count-distinc-Serie/m-p/577703#M1105634 <HTML><HEAD></HEAD><BODY><P>mmmm ok&nbsp; Gracias</P></BODY></HTML> Fri, 14 Mar 2014 16:42:23 GMT https://community.qlik.com/t5/QlikView/Sum-Count-distinc-Serie/m-p/577703#M1105634 2014-03-14T16:42:23Z