Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

HELP! How to do a function that contains Count, Sum, two distinct fields

Hello dear, I am wanting to build a KPI to count (count) Documents (Field DOC_CLI) Limited (distinct) when the sum of other Campo (VALO) is greater than zero 0.

How do I get the function adding the KPI tell me these SPDs when the sum of VALO is greater than zero?

FIELD = DOC-CLI

FIELD = VALO (contains numbers)

Hola estimados, estoy queriendo armar una KPI que cuente (count) de Documentos (DOC_CLI) Únicos (distinct) cuando la suma de otro Campo (VALO) sea mayor que Cero 0.


¿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?


CAMPO= DOC-CLI

CAMPO= VALO (contiene números)

0 Replies