Max value in expression with other corresponding column values

[#1]

Hello,

I am newbie to Qlikview.

I have the below input table in qlikview. I want result table productwise max sold qty with respective other columns.

Company	Product	Hour	Sold Qty
A	P1	10	25
A	P2	10	65
A	P3	10	34
A	P1	11	35
A	P2	11	50
A	P3	11	74
A	P1	12	40
A	P2	12	15
A	P3	12	24
B	T1	15	54
B	T2	15	45
B	T3	15	70
B	T1	16	104
B	T2	16	80
B	T3	16	65
B	T1	17	64
B	T2	17	95
B	T3	17	55

Output/Result should be as below.

Company	Product	Hour	Max(Sold Qty)
A	P1	12	40
A	P2	10	65
A	P3	11	74
B	T1	16	104
B	T2	17	95
B	T3	15	70

Kindly help to achieve the above result.

S. Anandh

[swuehl]

In a straight table chart, use dimensions Company and Product, then two expressions:

=FirstSortedValue( Hour, -[Sold Qty])

=Max([Sold Qty])

[#3]

Thanks Swuehi. It is working fine.