Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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 🙂