topic estadistica help.. in QlikView https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106259#M766905 <HTML><HEAD></HEAD><BODY><P>Hola estoy necesitando hacer una cuadro de estadisticas teniendo la siguiente informacion: </P><P>&nbsp; </P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD height="17" width="80">id</TD><TD width="80">leg</TD><TD width="80">name</TD><TD width="80">count(clientes)</TD></TR><TR><TD align="right" height="17">1</TD><TD align="right">11</TD><TD>jhon</TD><TD align="right">1000</TD></TR><TR><TD align="right" height="17">2</TD><TD align="right">22</TD><TD>maria</TD><TD align="right">2000</TD></TR><TR><TD align="right" height="17">3</TD><TD align="right">22</TD><TD>maria</TD><TD align="right">2000</TD></TR><TR><TD align="right" height="17">4</TD><TD align="right">11</TD><TD>jhon</TD><TD align="right">1000</TD></TR><TR><TD align="right" height="17">5</TD><TD align="right">66</TD><TD>marcos</TD><TD align="right">1000</TD></TR></TBODY></TABLE><P></P><P></P><P>Necesito obtener esto:</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="160"><TBODY><TR><TD colspan="2" height="17" width="160">Tabla de resultados</TD></TR><TR><TD height="17">value</TD><TD>total</TD></TR><TR><TD align="right" height="17">1000</TD><TD align="right">3</TD></TR><TR><TD align="right" height="17">2000</TD><TD align="right">2</TD></TR></TBODY></TABLE><P></P><P>desde ya muchas gracias!!!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT debcorne 2020-11-25T16:16:04Z estadistica help.. https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106259#M766905 <HTML><HEAD></HEAD><BODY><P>Hola estoy necesitando hacer una cuadro de estadisticas teniendo la siguiente informacion: </P><P>&nbsp; </P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="320"><TBODY><TR><TD height="17" width="80">id</TD><TD width="80">leg</TD><TD width="80">name</TD><TD width="80">count(clientes)</TD></TR><TR><TD align="right" height="17">1</TD><TD align="right">11</TD><TD>jhon</TD><TD align="right">1000</TD></TR><TR><TD align="right" height="17">2</TD><TD align="right">22</TD><TD>maria</TD><TD align="right">2000</TD></TR><TR><TD align="right" height="17">3</TD><TD align="right">22</TD><TD>maria</TD><TD align="right">2000</TD></TR><TR><TD align="right" height="17">4</TD><TD align="right">11</TD><TD>jhon</TD><TD align="right">1000</TD></TR><TR><TD align="right" height="17">5</TD><TD align="right">66</TD><TD>marcos</TD><TD align="right">1000</TD></TR></TBODY></TABLE><P></P><P></P><P>Necesito obtener esto:</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="160"><TBODY><TR><TD colspan="2" height="17" width="160">Tabla de resultados</TD></TR><TR><TD height="17">value</TD><TD>total</TD></TR><TR><TD align="right" height="17">1000</TD><TD align="right">3</TD></TR><TR><TD align="right" height="17">2000</TD><TD align="right">2</TD></TR></TBODY></TABLE><P></P><P>desde ya muchas gracias!!!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106259#M766905 debcorne 2020-11-25T16:16:04Z Re: estadistica help.. https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106260#M766906 <HTML><HEAD></HEAD><BODY><P>Just use Straight table and add dimension as Clientes and </P><P>expression Count(Clientes)</P></BODY></HTML> Tue, 03 Jul 2018 18:44:00 GMT https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106260#M766906 vishsaggi 2018-07-03T18:44:00Z Re: estadistica help.. https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106261#M766907 <HTML><HEAD></HEAD><BODY><P>i need this table </P><TABLE border="0" cellpadding="0" cellspacing="0" style="border: 0px; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;" width="160"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD colspan="2" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="160"></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">value</TD><TD style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">total</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD align="right" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">1000</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">3</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD align="right" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">2000</TD><TD align="right" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">2</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 03 Jul 2018 19:32:59 GMT https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106261#M766907 debcorne 2018-07-03T19:32:59Z Re: estadistica help.. https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106262#M766908 <HTML><HEAD></HEAD><BODY><P>Yes using straight table you can add dim as Value and </P><P>Count(Value) as your expression. Did you try?</P></BODY></HTML> Tue, 03 Jul 2018 19:40:37 GMT https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106262#M766908 vishsaggi 2018-07-03T19:40:37Z Re: estadistica help.. https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106263#M766909 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>It is simple and try like this.</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/206878_Capture.PNG" style="height: auto;" /></P><P><IMG alt="Capture1.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/206879_Capture1.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 04 Jul 2018 03:51:42 GMT https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106263#M766909 qlikviewwizard 2018-07-04T03:51:42Z Re: estadistica help.. https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106264#M766910 <HTML><HEAD></HEAD><BODY><P>Value is a metric.</P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Wed, 04 Jul 2018 11:42:40 GMT https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106264#M766910 debcorne 2018-07-04T11:42:40Z Re: estadistica help.. https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106265#M766911 <HTML><HEAD></HEAD><BODY><P>‌ok so what is the expr used ?</P></BODY></HTML> Wed, 04 Jul 2018 15:27:02 GMT https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106265#M766911 vishsaggi 2018-07-04T15:27:02Z Re: estadistica help.. https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106266#M766912 <HTML><HEAD></HEAD><BODY><P>the exp used is COUNT (Sales)</P></BODY></HTML> Wed, 04 Jul 2018 18:37:58 GMT https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106266#M766912 debcorne 2018-07-04T18:37:58Z Re: estadistica help.. https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106267#M766913 <HTML><HEAD></HEAD><BODY><P>‌sorry can you give us the original sample file to look into?</P></BODY></HTML> Wed, 04 Jul 2018 19:43:59 GMT https://community.qlik.com/t5/QlikView/estadistica-help/m-p/106267#M766913 vishsaggi 2018-07-04T19:43:59Z