Hello all,
On Qlik, the Min and Max functions accept a second parameter : the rank.
Min ( expr [, rank])
Return data type: numeric
Arguments:
Argument Description
expr | The expression or field containing the data to be measured. |
rank Expression | The default value of rank is 1, which corresponds to the lowest value. By specifying rank as 2, the second lowest value is returned. If rank is 3, the third lowest value is returned, and so on. |
I thinks this very cool and I use it in some scripts. However, sometimes, I need to do the exact same thing with strings. As you know, we then must use Minstring and Maxstring instead of Min and Max.
But there..... patatra : it just doesn't work
Syntax:
MinString ( expr )
![image.png image.png](https://community.qlik.com/t5/image/serverpage/image-id/48230i7F34757709CB40F8/image-size/large?v=v2&px=999)
So I would like the min/max string functions to work exactly like min /max. It seems easy and add consistence.
Best regards,
Simon
Bi Consultant (Dataviz & Dataprep) @ Business & Decision