Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Min() Function

I would like to get the minimum number but greater than ZERO.

how to do it using expression?

=Min(min(x)>0)

8 Replies
Highlighted
MVP
MVP

Try:

=Min({<x={'>0'}>} x)

Highlighted
Champion III
Champion III

May be try this too


=min ({<X > 0 >} X)


or


min ({<X -= {'0'}>} X)

Highlighted
Specialist
Specialist

May be this..

Min({<x={">0"}>} x)

Highlighted
Champion III
Champion III

or this too

Min({1<X={">0"}>} X)

Highlighted

You have got some good answers above, but in case they don't provide what you wanted, would you be able to elaborate on what exactly are you looking to get with an example and desired output?

Highlighted
Contributor II
Contributor II

Hi Hussain,

You can try as follows,

Min(if(X>0,X))

Highlighted
Not applicable

I'm not getting the right value from the above

Highlighted

Would you mind sharing more details? What do you have and what are you looking to get?