Rangemin not propagating NULL

[gmenoutis]

The documentation states:

Limitations:  

If no numeric value is found, NULL is returned.

However, it doesn't work that way with me.

Rangemin(NULL(),5) returns 5. Does anyone have any insight in this? This cripples my formula.

[vikasmahajan · Accepted solution]

refer https://community.qlik.com/t5/QlikView-App-Dev/RangeMin-and-RangeMax/td-p/1063690

Hope this helps

Vikas

[gmenoutis]

It needed a bit digging, but Swuehi said it:

"Hence, if there is only one numeric value in the range, it will return just this value."

Thanks

[tresesco]

---

@gmenoutis wrote:

The documentation states:

Limitations:  

If no numeric value is found, NULL is returned.

However, it doesn't work that way with me.

Rangemin(NULL(),5) returns 5. Does anyone have any insight in this? This cripples my formula.

---

Me too (confused - what's wrong here). 😋 .I don't know what is your expected output from the formula. May be there is some understanding gap. 'If no numeric values is found, NULL is returned' - it also means (if you read the actual function definition) that 'if numeric values are found  as an array - it returns minimum out of the list '. The function above has a numeric value (5); minimum of single number is itself, so it returns it. 

This also means - rangemin() would only return NULL, when there is not a single numeric value. 

Hope this helps.