Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
Maybe like
= COUNT({<CustomerField = {"=Sum(SalesField)>0"}>} DISTINCT CustomerField)
You need to replace CustomerField, SalesField with appropriate field names.
Thanks, it's working perfectly
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.