How to chose maximum values when dealing with alphanumeric data?

[that_anonymous_guy]

I have a table which have values like this

Product-1	A01
Product-1	A02
Product-1	B01
Product-1	C01
Product-1	C02
Product-1	C03
Product-2	A01
Product-2	B01
Product-2	B02
Product-2	C01

I want the final output like this

Product-1     C03

Product-2     C01

In A,B and C, C is the latest version and in C01 and C02, C02 is the latest. 

Basically it's like picking the latest version.

How can we do something like this in Qlik?

[marcus_sommer]

You may apply an aggregation like maxstring(), for example:

t: load P, S from X; inner join(t) load P, maxstring(S) as S resident t group by P;