Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
hiela001
Contributor
Contributor

find the Minimun based on Row

Hello , 

how can i get the min value based on row and not column as we always do . 
i want to get the min value for every customer based on the 3 Value columns in the pictue example . 

 

For customer A should be Value 3 the Min-value 
For Customer B should be Value 1 the Min- value

there is any solution for that ? 

1 Solution

Accepted Solutions
Or
MVP
MVP

RangeMin(Value1, Value2, Value3) should work here. RangeMin (and RangeMax) pick out the minimum (or maximum) value from a list of values.

View solution in original post

2 Replies
Or
MVP
MVP

RangeMin(Value1, Value2, Value3) should work here. RangeMin (and RangeMax) pick out the minimum (or maximum) value from a list of values.

hiela001
Contributor
Contributor
Author

Thank you @Or  it works fine 🙂