Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 3 field columns that I want to use in a Qlik Script.
I tried to type the function as:
MIN(Field 1, Field 2, Field 3)
However, when I begin to type Field 3 - Qlik Sense tells me that my function setup is incorrect.
Do you know how I can setup a MIN function so that I can find the MIN value between 3 field columns?
Hi
try rangemin() instead.
Robert
Thank you for providing this answer.
Do you know why MIN() is restricted and RANGEMIN() appears to have more flexibility?
Warm regards,
Vaughn Parker
They have different purposes.
min() is in script used when you have a group by clause, and it can take a second parameter if you want second smallest of several values of the same field.
rangemin() will not work on a group by clause and you can not get the second
[acidentally posted before finishing]
well, their purposes are different and in your scenario rangemin() made more sense.
Robert