Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ingoniclas
Creator II
Creator II

min() exclusively for positive values

I desperately need to know how to get the MIN of a range a numbers with positive and negative values, where only the positive values will be taken into account.

Example for the range of numbers:

6

2

-1

-5

Usually, if I stated min(numbers) -5 would be the outcome, however, I want 2 to be the outcome. How can I realize this?

1 Solution

Accepted Solutions
Not applicable

Try this:

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

View solution in original post

3 Replies
Not applicable

Try this:

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

marcus_malinow
Partner - Specialist III
Partner - Specialist III

or

nummax(0,(min(-1 * numbers) * -1))

ingoniclas
Creator II
Creator II
Author

Super! Thanks a lot!