Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Max of a Count Distinct

In my data we have transactions by customer Id.

I can do a count(Distinct custid) to find out how many unique customers i had over a period.

I can do count(distinct transId) to find out how many transactions i had over a period

What i would like to do now if to find what was the highest transaction count for the selected period by customer.

I don't need the customer itself, just the highest value.

Kind Regards

2 Replies
Highlighted
Not applicable

Max of a Count Distinct



Max

Seems to do it ....

(Aggr(Count(Distinct [Trans Id]), [MailCount]))



Highlighted
Champion III
Champion III

Max of a Count Distinct

Harry,
From your description, it should be aggregated by customer:
max(aggr(count(distinct transid),custid))