Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

Try this:

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

View solution in original post

3 Replies
Highlighted
Not applicable

Try this:

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

View solution in original post

Highlighted
Specialist III
Specialist III

or

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

Highlighted
Creator II
Creator II

Super! Thanks a lot!