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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to count 2 independent variables?

Hi:

I have a list of purchases per client and every transaction comes with different products. I need to count as one every transaction per client independently of the quantity. Needless to say, if a customer purchases 2 times, the answer should be 2

Thanks

10 Replies
Anonymous
Not applicable
Author

post sample data please so can help.

Not applicable
Author

The count should be "Destinatario" and "Document". E.G; The first client named "ZAIDA" has 3 different documents, so the answer should be 3.

Imagen1.png

settu_periasamy
Master III
Master III

Try,

Aggr(Count(Documents),Destinatario)

Not applicable
Author

This example is even better, theres 1 customer and 1 document, but 8 different products, and the answer should be 1

Imagen2.png

Not applicable
Author

didn't worked

Anonymous
Not applicable
Author

maybe try:

Aggr(Count(Documents),Cliente)

Not applicable
Author

Still 8

Anonymous
Not applicable
Author

Aggr(Count(Distinct Documents),Cliente)

Not applicable
Author

Doesn't work