Discussion Board for collaboration related to QlikView App Development.
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.
Seems to do it ....
Harry,From your description, it should be aggregated by customer:max(aggr(count(distinct transid),custid))