topic HELP! How to do a function that contains Count, Sum, two distinct fields in App Development https://community.qlik.com/t5/App-Development/HELP-How-to-do-a-function-that-contains-Count-Sum-two-distinct/m-p/1050110#M16528 <HTML><HEAD></HEAD><BODY><P><STRONG>Hello dear, I am wanting to build a KPI to count (count) Documents (</STRONG><EM>Field</EM><STRONG> DOC_CLI) Limited (distinct) when the sum of other Campo (</STRONG><STRONG>VALO) is greater than zero 0.</STRONG></P><P></P><P></P><P><STRONG style="color: #ff0000;">How do I get the function adding the KPI tell me these SPDs when the sum of VALO is greater than zero?</STRONG></P><P></P><P></P><P><STRONG>FIELD = DOC-CLI</STRONG></P><P><STRONG>FIELD = VALO (contains numbers)</STRONG></P><P></P><P></P><P><SPAN style="color: #000000;">Hola estimados, estoy queriendo armar una KPI que cuente (count) de Documentos (DOC_CLI) Únicos (distinct) cuando la <SPAN style="text-decoration: underline;">suma</SPAN> de otro Campo (VALO) sea mayor que Cero 0.<SPAN style="font-size: 14.6667px; font-family: Calibri, sans-serif;"><EM> </EM></SPAN></SPAN></P><P><SPAN style="color: #000000; font-size: 14.6667px; font-family: Calibri, sans-serif;"><EM><BR /></EM></SPAN></P><P><SPAN style="color: #000000; font-size: 14.6667px; font-family: Calibri, sans-serif;"><EM style="color: #ff0000;">¿Cómo hago para que agregando en la Función de la KPI me cuente estos Documentos Únicos cuando la suma de VALO sea mayor a Cero?</EM></SPAN></P><P><SPAN style="color: #000000; font-size: 14.6667px; font-family: Calibri, sans-serif;"><EM><BR /></EM></SPAN></P><P><SPAN style="color: #000000; font-size: 14.6667px; font-family: Calibri, sans-serif;">CAMPO= DOC-CLI</SPAN></P><P><SPAN style="color: #ff0000; font-size: 14.6667px; font-family: Calibri, sans-serif;"><SPAN style="color: #000000;">CAMPO= VALO (contiene números)</SPAN><BR /></SPAN></P></BODY></HTML> Fri, 29 Apr 2016 19:04:52 GMT Anonymous 2016-04-29T19:04:52Z HELP! How to do a function that contains Count, Sum, two distinct fields https://community.qlik.com/t5/App-Development/HELP-How-to-do-a-function-that-contains-Count-Sum-two-distinct/m-p/1050110#M16528 <HTML><HEAD></HEAD><BODY><P><STRONG>Hello dear, I am wanting to build a KPI to count (count) Documents (</STRONG><EM>Field</EM><STRONG> DOC_CLI) Limited (distinct) when the sum of other Campo (</STRONG><STRONG>VALO) is greater than zero 0.</STRONG></P><P></P><P></P><P><STRONG style="color: #ff0000;">How do I get the function adding the KPI tell me these SPDs when the sum of VALO is greater than zero?</STRONG></P><P></P><P></P><P><STRONG>FIELD = DOC-CLI</STRONG></P><P><STRONG>FIELD = VALO (contains numbers)</STRONG></P><P></P><P></P><P><SPAN style="color: #000000;">Hola estimados, estoy queriendo armar una KPI que cuente (count) de Documentos (DOC_CLI) Únicos (distinct) cuando la <SPAN style="text-decoration: underline;">suma</SPAN> de otro Campo (VALO) sea mayor que Cero 0.<SPAN style="font-size: 14.6667px; font-family: Calibri, sans-serif;"><EM> </EM></SPAN></SPAN></P><P><SPAN style="color: #000000; font-size: 14.6667px; font-family: Calibri, sans-serif;"><EM><BR /></EM></SPAN></P><P><SPAN style="color: #000000; font-size: 14.6667px; font-family: Calibri, sans-serif;"><EM style="color: #ff0000;">¿Cómo hago para que agregando en la Función de la KPI me cuente estos Documentos Únicos cuando la suma de VALO sea mayor a Cero?</EM></SPAN></P><P><SPAN style="color: #000000; font-size: 14.6667px; font-family: Calibri, sans-serif;"><EM><BR /></EM></SPAN></P><P><SPAN style="color: #000000; font-size: 14.6667px; font-family: Calibri, sans-serif;">CAMPO= DOC-CLI</SPAN></P><P><SPAN style="color: #ff0000; font-size: 14.6667px; font-family: Calibri, sans-serif;"><SPAN style="color: #000000;">CAMPO= VALO (contiene números)</SPAN><BR /></SPAN></P></BODY></HTML> Fri, 29 Apr 2016 19:04:52 GMT https://community.qlik.com/t5/App-Development/HELP-How-to-do-a-function-that-contains-Count-Sum-two-distinct/m-p/1050110#M16528 Anonymous 2016-04-29T19:04:52Z