topic Re: Oracle QlikView filter by max()? in QlikView

Oracle QlikView filter by max()?

Mon, 14 Sep 2015 14:57:06 GMT

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.

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

Any ideas?

Thanks for any help!

Oliver

hic — Tue, 15 Sep 2015 08:49:18 GMT

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 — Tue, 15 Sep 2015 08:52:41 GMT

Hi Oliver,

Table

Load *;

SQL SELECT * FROM ..... ;

Load Name, Max(Version) as Version

Resident Table

Group By Name;

qlikmsg4u — Tue, 15 Sep 2015 08:55:30 GMT

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> ;