Return Last String In Field

Wed, 30 Mar 2011 15:31:41 GMT

Claimant Type	Claim Number	Ver No	Payment Reserves	Recovery Reserves	Payments	RI Recoveries	Non RI Recoveries	Incurred	Status
AD	RS100202	1	925.00	0.00	0.00	0.00	0.00	925	O
AD	RS100202	2	925.00	0.00	0.00	0.00	0.00	925	O
AD	RS100202	3	925.00	0.00	0.00	0.00	0.00	925	O
PI	RS100202	1	4585.00	0.00	0.00	0.00	0.00	4585	O
PI	RS100202	2	4585.00	0.00	0.00	0.00	0.00	4585	O
PI	RS100202	3	4585.00	0.00	0.00	0.00	0.00	4585	O
TP	RS100202	1	1000.00	0.00	0.00	0.00	0.00	1000	O
TP	RS100202	2	1000.00	0.00	0.00	0.00	0.00	1000	O
TP	RS100202	3	1000.00	0.00	0.00	0.00	0.00	1000	O

i have this original set of data.

i need a table which returns the highest Ver No. for each claimant Type. and all the other records which correspond to that max version number. (see below)

Claimant Type	Claim Number	Ver No	Payment Reserves	Recovery Reserves	Payments	RI Recoveries	Non RI Recoveries	Incurred	Status
TP	RS100202	3	1000.00	0.00	0.00	0.00	0.00	1000	O
PI	RS100202	3	4585.00	0.00	0.00	0.00	0.00	4585	O
AD	RS100202	3	925.00	0.00	0.00	0.00	0.00	925	O

Thank you in advance

Return Last String In Field

Wed, 30 Mar 2011 15:40:52 GMT

Try creating a straight table with set analysis expression such as:

only({$<VerNo=$(=max(VerNo))>} PaymentReserves)

Return Last String In Field

Wed, 30 Mar 2011 15:58:17 GMT

I have tried it. why doesn't this work? forgive me i am new to the systme still.

only({$<[Claim Transaction Sequence Number]=$(=max([Claim Transaction Sequence Number]))>} [Claimant Payment])

topic Return Last String In Field in QlikView

Return Last String In Field

Return Last String In Field

Return Last String In Field