Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
refer https://community.qlik.com/t5/QlikView-App-Dev/RangeMin-and-RangeMax/td-p/1063690
Hope this helps
Vikas
refer https://community.qlik.com/t5/QlikView-App-Dev/RangeMin-and-RangeMax/td-p/1063690
Hope this helps
Vikas
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
@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.