How have positive values? (¿Como contar valores positivos?)

[#1]

Hello:

I have to make a count of customers who have purchased over a period "x" and is taking positive values. I'm new and I do not drive qlikview much. I'm using the following count formula (distinct [address]) but I need consider only those customers who purchase volume is positive (sometimes no returns they generate negative sales volume).

Translated with Google Translate - Qlik Community Administrative Team

Hola:

Tengo que realizar un conteo de clientes que han comprado durante un periodo "x" y está tomando los valores positivos. Soy nuevo en qlikview y no me manejo mucho. estoy usando la siguiente formula count(distinct [Direccion]) pero necesito que sólo me considere aquellos clientes que su volumen de compra sea positivo (a veces hay devoluciones que generan un volumen de venta negativo).

[swuehl]

Maybe like

= COUNT({<CustomerField = {"=Sum(SalesField)>0"}>} DISTINCT  CustomerField)

You need to replace CustomerField, SalesField with appropriate field names.

[#3]

Thanks, it's working perfectly

[#4]

Hello,

Good afternoon,
I was very helpful the answer!

But I would like to know if it is possible to apply this selection to the entire data cloud
And not just a specific object.

Greetings and thanks.