topic Re: find the Minimun based on Row in QlikView

find the Minimun based on Row

hiela001 — Tue, 23 Nov 2021 13:42:13 GMT

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 ?

Re: find the Minimun based on Row

Or — Tue, 23 Nov 2021 13:44:11 GMT

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

Re: find the Minimun based on Row

hiela001 — Wed, 24 Nov 2021 08:58:24 GMT

Thank you @Or it works fine 🙂