2 Replies Latest reply: Aug 6, 2014 9:55 AM by Janani Kumar RSS

    How to remove duplicates in FirstSortedValue?

    Janani Kumar

      Hi, I need to find which [Sales Person] has performed well in a country? Here is my input table

      CountryStateCitySales Personsale
      ArgentinaBuenos AiresAyacuchoPamela1200
      AustraliaNew South WalesAvalonAnke3600
      AustraliaNew South WalesLindfiledJacob3600
      AustriaViennaInner CityCorina3600
      AustriaViennaMid CityCorine5000

       

      My output in qlikview:

      Country Largest Sales By SaleRep FirstSortedValue(SalesPerson,-aggr(sum(Sale),Country,SalesPerson))
      5000 Mike
      Argentia1200Jan
      Australia3600
      Austria5000Mike

       

      So there is null value in my 2nd row. Hence how do I remove duplicate or how should I bring my top Performer with repeated value?

      Any help appreciated?