1 Reply Latest reply: Jul 13, 2011 2:41 PM by Jean-Jacques Jesua RSS

    Top Sales Person for a given city

      Hello,
      I am new to Qlikview and was trying to figure out how to get the top sales person for a given city.  For Example:
      Atlanta:  John Doe
      Charlotte: John Doe
      Birmingham: John Doe
      Tampa: Bill Jones
      Miami:  Bill Jones
      Newark: Todd Smith
      Orlando: Todd Smith
      Based on some searches on the community forums, I built the following function:
      only({<SalesPerson= {"=rank(sum(LineSalesAmount),City,SalesPerson) =1"}>} SalesPerson )
      This yields the following results:
      Atlanta:  John Doe
      Charlotte: John Doe
      Birmingham: John Doe
      Tampa: <blank>
      Miami: <blank>
      Newark:<blank>
      Orlando: <blank>
      What am I missing?  Any help is always appreciated.
      Regards,
      Joe