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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
debcorne
Contributor II
Contributor II

estadistica help..

Hola estoy necesitando hacer una cuadro de estadisticas teniendo la siguiente informacion:

 

 

idlegnamecount(clientes)
111jhon1000
222maria2000
322maria2000
411jhon1000
566marcos1000

Necesito obtener esto:

 

Tabla de resultados
valuetotal
10003
20002

desde ya muchas gracias!!!

8 Replies
vishsaggi
Champion III
Champion III

Just use Straight table and add dimension as Clientes and

expression Count(Clientes)

debcorne
Contributor II
Contributor II
Author

i need this table

valuetotal
10003
20002
vishsaggi
Champion III
Champion III

Yes using straight table you can add dim as Value and

Count(Value) as your expression. Did you try?

qlikviewwizard
Master II
Master II

Hi,

It is simple and try like this.

Capture.PNG

Capture1.PNG

debcorne
Contributor II
Contributor II
Author

Value is a metric.

vishsaggi
Champion III
Champion III

‌ok so what is the expr used ?

debcorne
Contributor II
Contributor II
Author

the exp used is COUNT (Sales)

vishsaggi
Champion III
Champion III

‌sorry can you give us the original sample file to look into?