Showing a specific row in a table

Thu, 17 Mar 2011 10:36:00 GMT

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

Showing a specific row in a table

matt_crowther — Thu, 17 Mar 2011 10:59:26 GMT

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

topic Showing a specific row in a table in QlikView

Showing a specific row in a table

Showing a specific row in a table