topic Re: Min >0 in QlikView

Min >0

kevbrown — Thu, 29 Jun 2017 09:54:15 GMT

I have a rang of number, some negative some positive and I want to pull out the smallest which is greater than Zero

Field

-50

-20

-5

I want to pull out 2 from my data, I've tried =min ({<Field > 0 >} Field) but it doesn't like it

swuehl — Thu, 29 Jun 2017 09:56:06 GMT

Try

=min ({<Field = {">0"} >} Field)

tresB — Thu, 29 Jun 2017 09:56:20 GMT

Try like:

min ({<Field ={'>0'} >} Field)

Kushal_Chawda — Thu, 29 Jun 2017 10:06:39 GMT

min(if(Field>0,Field))

BalaBhaskar_Qlik — Thu, 29 Jun 2017 10:11:27 GMT

Try like this:

=Min(If(Field>0,Field))

ils4nt0 — Wed, 27 Jul 2022 13:26:14 GMT

this works! you male my day!