topic Re: Customer having maximum Invoice in Text Box in QlikView

Customer having maximum Invoice in Text Box

Mon, 26 Jan 2026 18:19:17 GMT

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 — Sat, 20 Sep 2014 08:50:56 GMT

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 — Sat, 20 Sep 2014 09:05:53 GMT

see the file

maxgro — Sat, 20 Sep 2014 09:15:35 GMT

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

or also here