Customer having maximum Invoice in Text Box

[#1]

Hi

i am new to qlikview

i was trying to show Customer having maximum Invoice in Text Box

but i don't know how to do it

attaching here database and app

i created strait table but can't show max invo customer in text box

please help me

thanks

[MK_QSL · Accepted solution]

Number of Invoices for each customer

COUNT(DISTINCT [Invoice NO])

Customer having Maximum Invoices in Text Box...

=FirstSortedValue(Customer, -Aggr(Count(DISTINCT [Invoice NO]),Customer))

[ecolomer]

see the file

[maxgro]

=only({$<Customer={"=rank(Count ([Invoice NO]))=1"}>} Customer)

or also here

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/08/displaying-the-top-salesperson-in-a-te...