Need help determining the minimum value between 2 values

[#1]

I guess in Excel you can do something like =Minimum(value1, value2), and thats something I would like to do here. Is there something like this I can do in Qlikview? Thanks

[MK_QSL]

RangeMin(Value1,Value2)

[JonnyPoole]

Like this:

If ( Value1>=Value2 , Value2, Value1)

If value1=value2 this will use value1 for the result.

this will evaluate the values from a row of data from the data model where Value1  and Value2 are data fields.

Is that what you want ?  there could be a few possibilities here....

[its_anandrjs]

Hi,

In qlikview you can do this in load script and use that table

Ex:-

Tab1:

Load * Inline

[

ID,Value1,Value2

1,10,45

2,20,12

3,30,48

4,40,16

5,50,18

];

MinValue:

Load

ID,

Min(Value1) as MinValue1,

MIn(Value2) as MinValue2

Resident Tab1

Group By ID;

Any sample data if having provide that

Regards

Anand