Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to count distinct product for each customer in expressions?

Hello

Help me please, how to count distinct product for each customer in expressions (red figures)?

001_.jpg

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Could you upload a small sample application?

Customer and Product are dimensions in a table chart right, but not the only two dimensions, there are some more, right?

I think something like

=COUNT(TOTAL<Customer> DISTINCT Product)

as expression should return what you want.

View solution in original post

5 Replies
MK_QSL
MVP
MVP

Aggr(Count(DIstinct Product),Customer)

or

Count (Distinct <Customer> Product)

Not applicable
Author

with AGGR result is:

0002_.jpg

>>Count (Distinct <Customer> Product)

here is QV writes about error.

Not applicable
Author

I want to show only customers&products with products count = variable

swuehl
MVP
MVP

Could you upload a small sample application?

Customer and Product are dimensions in a table chart right, but not the only two dimensions, there are some more, right?

I think something like

=COUNT(TOTAL<Customer> DISTINCT Product)

as expression should return what you want.

View solution in original post

Not applicable
Author

thank you! it's works!