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.

[buzzy996]

seems to be u don't have max no data for this date 02/10/2014?can u cross check ur source data...pls.

[#3]

it is there. The out put for ID = Rt0976 is

ID       Region        DateManufacture   No   Kety    Moniyt    Notax

Rt0976       US          02/10/2014      13   677      613

[MK_QSL]

=Max(TOTAL <ID> {<No = {'$(=Max(No))'}, Moniyt = {'$(=Max(Moniyt))'}, Kety = {'$(=Max(Kety))'}>}DateManufacture)

[#5]

Thanks. Really sorry!. Just I got the requirement changed from the user.

All I need now is to dhow

for eg: ID=Rt0976

I need to show all 39 records.

Can you please change the expression and send me please.

[MK_QSL]

What is you use max(No) or Max(Total <ID> No)

[#7]

I need Max(No)

so, for ID = Rt0976      No = 13

table should display all 39 rows.

is it possible?

[timanshu]

Hi

See attached qvw

[MK_QSL]

I think you try below expression

MAX(TOTAL <ID> No)

and let me know if it's working or not...

[#10]

Thanks. when I used this the data is showing more.

for eg: In excel for ID = Rt0976   there are 39 rows

but it is showing duplicates more.

Please can sort this.

[#11]

Please can help me. I am really struggling with this since two days.