Showing a specific row in a table

[#1]

Hi All

As you can see in the tables below I am trying to show only the rows with the latest Claim transaction sequence number. I have tried many ways to no avail can someone help please.

What I Have
Claim Transaction Sequence Number	Claim Number	Total Loss Payments
		9700.00
8	RS100061	1000.00
9	RS100061	1000.00
10	RS100061	1000.00
11	RS100061	1000.00
12	RS100061	1000.00
13	RS100061	1000.00
14	RS100061	1000.00
3	XA100189	900.00
4	XA100189	900.00
5	XA100189	900.00
What I am trying to achieve
Claim Transaction Sequence Number	Claim Number	Total Loss Payments
		1900.00
14	RS100061	1000.00
5	XA100189	900.00

Regards

[matt_crowther]

Try something similar to my solution from this post - obviously replacing the Date with your ClaimTransactionSequence to drive the sorting.

Essentially you're creating a flag in the load script for the most recent (in your case highest valued) date / Transaction which will then allow you to use an 'if' in the table to exclude all rows without the flag.

http://community.qlik.com/forums/p/42628/168957.aspx#168957

Hope that helps,

Matt - Visual Analytics Ltd