topic Find a min value in QlikView

Find a min value

Thu, 22 Oct 2015 19:24:20 GMT

Hello, i have a list of customer and value. I want find a customer and her min value. I have attached a photo with the my problem.

Thanks.

Re: Find a min value

sunny_talwar — Thu, 22 Oct 2015 19:39:12 GMT

See this may be:

Expressions:

1) =FirstSortedValue(Customer, Aggr(Only(Value), Customer, Value))

2) =Min(Value)

Re: Find a min value

MK_QSL — Thu, 22 Oct 2015 19:39:48 GMT

Create a Straight Table

Dimension

No Dimension

Expression

1) Min(Value)

2) FirstSortedValue(Customer, Value)

Re: Find a min value

MarcoWedel — Thu, 22 Oct 2015 21:08:36 GMT

Hi,

another solution could be an expression like this:

=Only({$<Value={"=Value=Min(TOTAL Value)"}>} Value)

hope this helps

regards

Marco

Re: Find a min value

JonasValleskog — Thu, 22 Oct 2015 21:28:17 GMT

The simplest solution I can think of would look like this:

Dim:

Customer

Exp:

if(min(TOTAL Value)=min(Value),min(Value))

Re: Find a min value

Fri, 23 Oct 2015 12:30:49 GMT

Hello, thank for the answer. This code works only if there only one value minium. For example there is only A = 10. But if there is A = 10 and B = 10, it write only A = 10.

How works this code: $<Value={"=Value=Min(TOTAL Value)"}>

Re: Find a min value

HirisH_V7 — Fri, 23 Oct 2015 13:01:45 GMT

Hi,

In straight table ,

Dimension:

=if(match(Customer ,'B'),Customer)

-SupressNull

Expression:

=Min(Value)

Thanks,

Hirish