How to show rows only have top values?

[#1]

Hi,

I have data as below. How to get the table in qvw only to show rows which is Max(No)

for eg:

considering below sample data I need to show output only the row

S908779       US          11/06/2013       20         19038                 56                     64563

ID	Region	DateManufacture	No	Kety	Moniyt	Notax
S908766	US	11/03/2013	20		0
S908767	US	11/03/2013	10	461	461
S908768	US	11/03/2013	8		461
S908769	US	01/04/2013	1	461	461
S908770	US	11/04/2013	10	461	461
S908771	US	11/04/2013	8	510	461
S908772	US	11/04/2013	20	345	355	23423
S908773	US	01/05/2013	1	461	461
S908774	US	11/05/2013	8	510	461
S908775	US	11/05/2013	10	461	461
S908776	US	11/05/2013	20	345	34	5534
S908777	US	01/06/2013	1	461	461
S908778	US	11/06/2013	10	461	461
S908779	US	11/06/2013	20	19038	56	64563
S908780	US	11/06/2013	8	510	461
S908781	US	01/07/2013	1	461	461
S908782	US	11/07/2013	10	461	461
S908783	US	11/07/2013	13	510	461
S908784	US	11/07/2013	8		461
S908785	US	11/07/2013	20	24	56	5465
S908786	US	01/08/2013	1	461	461
S908787	US	11/08/2013	10	461	461

Can anyone suggest me please.

Thanks.

[sunny_talwar]

There are other rows that have no = 20 why would you exclude them from your output for the constraint you have. Are you looking for Max(Kety) instead?? then the output would make sense.

Best,

Sunny

[#3]

yes you are right. I need the Max(No) and the corresponding max values for this Max.

Is it possible?

please help me.

[MK_QSL]

What is Max(No)?

[#5]

sorry. that I mean is Maximum value of the column No

[MK_QSL]

Can you provide few lines of sample data please?

[#7]

Please see attached and help me.

[Anonymous]

Would using a Straight Table with the Dimensions you want and an Expression like this help ?

only ( { <No={'$(=max(No))'}>} No )

[#9]

Thanks. This is showing all values for maximum 20. But I need to display only one row. so, for

ID = S908779 I need straight table to show only

S908779    US    11/06/2013   20    19038      56   64563

is it possible. Please help. I have tried many ways but nothing seems working.

[settu_periasamy]

Put like this

only ( { <No={'$(=max(No))'},Kety={'$(=max(Kety))'}>} No )