Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Jesus_Ojeda
Contributor
Contributor

contar dos columnas

Hola, estoy intentando contar el numero de proveedores en base al estatus, alguien me puede decir que formula debo de usar? es importante mencionar que el conteo debe de ser distinto ya que el proveedor se repite varias veces.

Sin título.jpg

 

esta es la formula que intente utilizar:

=Aggr (COUNT (DISTINCT [FI_Estatus P O]), [ProveedorGeneral])

 

Labels (1)
1 Reply
Chanty4u
Champion III
Champion III

try this

what is the result for  this     count( distinct Status) ?

 

or  

aggr(count(distinct status),field1,field2)

or 

 

count(Status)/count(total <Name> Status)