Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Find a min value

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.

1 Solution

Accepted Solutions
jonascbi
New Contributor III

Re: Find a min value

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

Dim:

Customer

Exp:

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

6 Replies

Re: Find a min value

See this may be:

Capture.PNG

Expressions:

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

2) =Min(Value)

Re: Find a min value

Create a Straight Table

Dimension

No Dimension

Expression

1) Min(Value)

2) FirstSortedValue(Customer, Value)

Re: Find a min value

Hi,

another solution could be an expression like this:

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

QlikCommunity_Thread_188789_Pic1.JPG

QlikCommunity_Thread_188789_Pic2.JPG

QlikCommunity_Thread_188789_Pic3.JPG

hope this helps

regards

Marco

jonascbi
New Contributor III

Re: Find a min value

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

Dim:

Customer

Exp:

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

Not applicable

Re: Find a min value

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)"}>

hirishv7
Honored Contributor

Re: Find a min value

Hi,

In straight table ,

Dimension:

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

-SupressNull

Expression:

=Min(Value)

Thanks,

Hirish

Community Browser