Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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