topic Re: Get row having max value in straight table in QlikView

Get row having max value in straight table

Wed, 25 Nov 2020 16:16:04 GMT

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 .

Re: Get row having max value in straight table

sunny_talwar — Tue, 21 Feb 2017 10:24:06 GMT

Like this?

Dimension

Date

Expression

=FirstSortedValue(ItemNo, -Qty)

=Max(Qty)

Re: Get row having max value in straight table

Tue, 21 Feb 2017 10:52:13 GMT

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

Re: Get row having max value in straight table

sunny_talwar — Tue, 21 Feb 2017 10:56:20 GMT

Try this

Dimension

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

Expression

Qty

Date

Re: Get row having max value in straight table

Tue, 21 Feb 2017 11:06:45 GMT

Thanks ! Work fine for me !