Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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))
see the file
=only({$<Customer={"=rank(Count ([Invoice NO]))=1"}>} Customer)
or also here