Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Oracle QlikView filter by max()?

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

 

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

Either of the two following will work:

SQL SELECT Name, Max(Version) as Version FROM <Table> GROUP BY Name;

Load Name, Max(Version) as Version Group By Name;

SQL SELECT * FROM <Table> ;

HIC

View solution in original post

3 Replies
hic
Former Employee
Former Employee

Either of the two following will work:

SQL SELECT Name, Max(Version) as Version FROM <Table> GROUP BY Name;

Load Name, Max(Version) as Version Group By Name;

SQL SELECT * FROM <Table> ;

HIC

Anonymous
Not applicable
Author

Hi Oliver,

Table

Load *;

SQL SELECT * FROM ..... ;

Load Name, Max(Version) as Version

Resident Table

Group By Name;

qlikmsg4u
Specialist
Specialist

Use

SQL SELECT Name, Max(Version) as Version FROM <Table> GROUP BY Name;


if you want do it in SQL Side, otherwise use (Will Decrease load on qlikview)


Load Name, Max(Version) as Version Group By Name;

SQL SELECT * FROM <Table> ;