Get row having max value in straight table

[#1]

Hello ,

Let's say I have a inline table:

Data:

LOAD * INLINE [

ItemNo, Qty, Date

44444, 100, 24.01.2013

66666, 99, 25.01.2013

55555, 100, 25.01.2013

77777, 50, 24.01.2013

];

The goal is to have in a chart (Straight Table for example) all line having the max value of Qty, for example :

          ItemNo, Qty, Date

44444, 100, 24.01.2013

55555, 100, 25.01.2013

Any idea ?

Thanks in advance for your help .

[sunny_talwar]

Like this?

Dimension

Date

Expression

=FirstSortedValue(ItemNo, -Qty)

=Max(Qty)

[#3]

Hi and thanks for your help.

It's not realy what I expected :

Taking the same example with 2 new lines :

Data:

LOAD * INLINE [

ItemNo, Qty, Date

44444, 100, 24.01.2013

66666, 99, 25.01.2013

55555, 100, 25.01.2013

77777, 50, 24.01.2013

88888, 200, 21.01.2013

99999, 200, 20.01.2013

];

that's what I expect :

88888, 200, 21.01.2013

99999, 200, 20.01.2013

What I expect  i not the max by date but all lines having qty = max(Qty), that's the difficulty, sorry for my poor English

[sunny_talwar · Accepted solution]

Try this

Dimension

=If(Qty = Max(TOTAL Qty), ItemNo)

Expression

Qty

Date

[#5]

Thanks ! Work fine for me !