topic Re: Need help determining the minimum value between 2 values in QlikView

Need help determining the minimum value between 2 values

Mon, 03 Nov 2014 14:23:33 GMT

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

Re: Need help determining the minimum value between 2 values

MK_QSL — Mon, 03 Nov 2014 14:26:06 GMT

RangeMin(Value1,Value2)

Re: Need help determining the minimum value between 2 values

JonnyPoole — Mon, 03 Nov 2014 14:27:12 GMT

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....

Re: Need help determining the minimum value between 2 values

its_anandrjs — Mon, 03 Nov 2014 14:37:56 GMT

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