topic Re: Minimum of two fields in QlikView https://community.qlik.com/t5/QlikView/Minimum-of-two-fields/m-p/598713#M221675 <HTML><HEAD></HEAD><BODY><P>hi</P><P>also try this</P><P>if(A&lt;B,A,if(B&lt;A,B))</P></BODY></HTML> Mon, 03 Feb 2014 07:46:25 GMT 2014-02-03T07:46:25Z Minimum of two fields https://community.qlik.com/t5/QlikView/Minimum-of-two-fields/m-p/598709#M221671 <HTML><HEAD></HEAD><BODY><P><BR />Hi All,</P><P></P><P>I have two fields like below. I would like to see the minimum value of those two fields in third field with our uisng IF condition.</P><P></P><P>A&nbsp;&nbsp;&nbsp;&nbsp; B&nbsp;&nbsp;&nbsp;&nbsp; C</P><P>10&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp; </P><P>20&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp; 15</P><P>5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2</P><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 03 Feb 2014 07:41:18 GMT https://community.qlik.com/t5/QlikView/Minimum-of-two-fields/m-p/598709#M221671 2014-02-03T07:41:18Z Re: Minimum of two fields https://community.qlik.com/t5/QlikView/Minimum-of-two-fields/m-p/598710#M221672 <HTML><HEAD></HEAD><BODY><P>RangeMin(A,B,C)</P></BODY></HTML> Mon, 03 Feb 2014 07:42:50 GMT https://community.qlik.com/t5/QlikView/Minimum-of-two-fields/m-p/598710#M221672 MK_QSL 2014-02-03T07:42:50Z Re: Minimum of two fields https://community.qlik.com/t5/QlikView/Minimum-of-two-fields/m-p/598711#M221673 <HTML><HEAD></HEAD><BODY><P>or RangeMin(A,B) as C</P></BODY></HTML> Mon, 03 Feb 2014 07:43:07 GMT https://community.qlik.com/t5/QlikView/Minimum-of-two-fields/m-p/598711#M221673 MK_QSL 2014-02-03T07:43:07Z Re: Minimum of two fields https://community.qlik.com/t5/QlikView/Minimum-of-two-fields/m-p/598712#M221674 <HTML><HEAD></HEAD><BODY><P>Load *,If(A&lt;B, A,B) as C Inline</P><P>[</P><P>&nbsp;&nbsp;&nbsp;&nbsp; A, B</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 10,12</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 20,15</P><P>&nbsp;&nbsp;&nbsp;&nbsp; 5,2</P><P>];</P></BODY></HTML> Mon, 03 Feb 2014 07:44:19 GMT https://community.qlik.com/t5/QlikView/Minimum-of-two-fields/m-p/598712#M221674 MK_QSL 2014-02-03T07:44:19Z Re: Minimum of two fields https://community.qlik.com/t5/QlikView/Minimum-of-two-fields/m-p/598713#M221675 <HTML><HEAD></HEAD><BODY><P>hi</P><P>also try this</P><P>if(A&lt;B,A,if(B&lt;A,B))</P></BODY></HTML> Mon, 03 Feb 2014 07:46:25 GMT https://community.qlik.com/t5/QlikView/Minimum-of-two-fields/m-p/598713#M221675 2014-02-03T07:46:25Z