Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Minimum of two fields


Hi All,

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.

A     B     C

10     12     10    

20     15     15

5       2       2

Thanks in advance.

Tags (4)
1 Solution

Accepted Solutions
MVP
MVP

Re: Minimum of two fields

4 Replies
MVP
MVP

Re: Minimum of two fields

MVP
MVP

Re: Minimum of two fields

or RangeMin(A,B) as C

MVP
MVP

Re: Minimum of two fields

Load *,If(A<B, A,B) as C Inline

[

     A, B

     10,12

     20,15

     5,2

];

Not applicable

Re: Minimum of two fields

hi

also try this

if(A<B,A,if(B<A,B))