7 Replies Latest reply: Jul 3, 2015 3:47 PM by Sinan Ozdemir RSS

    QlikSense Distinct Filter

      New guy here....

       

      I'm sure this is simple and I'm searching the forums, but I think I'm probably searching on the wrong terms or trying to tackle this problem the wrong way.

       

      I have a simple table that I want to filter out duplicates in certain dimensions but not others (in the same way I can filter out null values in some dimensions but leave them others).  So in my table below, I want to filter out the duplicate values in the WRKORDNBR dimension.  Ultimately, I want to create a measure that will total the AMTBILLED dimension where WRKORDNBR is unique.  So on the example below, I only care about the first row where WRKORDNBR was 962217 and would like to hide the second row (with the later SUMMIT DATE).

      Capture.PNG

      Thanks!