3 Replies Latest reply: Sep 15, 2015 4:55 AM by Kalyan Navuluri RSS

    Oracle QlikView filter by max()?

    Oliver Krause

      Dear all,

       

      I need to read in a database table from Oracle and need to filter somehow:

      Each DB entry in the table has a name and a version [1..5], e.g.

      Name

      Version

      myName1

      1

      myName1

      2

      myName2

      1

      myName2

      2

      myName2

      3

      myName2

      4

      myName3

      1

       

      How can I get a list of the entries with the highest version numbers, i.e.:

      Name

      Version

      myName1

      2

      myName2

      4

      myName3

      1

       

      Any ideas?

       

       

      Thanks for any help!

      Oliver