Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
JonasValleskog
Partner - Creator
Partner - Creator

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

Dim:

Customer

Exp:

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

View solution in original post

6 Replies
sunny_talwar

See this may be:

Capture.PNG

Expressions:

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

2) =Min(Value)

MK_QSL
MVP
MVP

Create a Straight Table

Dimension

No Dimension

Expression

1) Min(Value)

2) FirstSortedValue(Customer, Value)

MarcoWedel

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

JonasValleskog
Partner - Creator
Partner - Creator

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

Dim:

Customer

Exp:

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

Not applicable
Author

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

HirisH_V7
Master
Master

Hi,

In straight table ,

Dimension:

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

-SupressNull

Expression:

=Min(Value)

Thanks,

Hirish

HirisH
“Aspire to Inspire before we Expire!”