Qlik Community

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

Minstring and Maxstring should accept rank as 2nd parameter(like min/max)

simonaubert
Partner
Partner

Minstring and Maxstring should accept rank as 2nd parameter(like min/max)

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
exprThe 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

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
Tags (2)
2 Comments
msteedle
Luminary Alumni
Luminary Alumni

You can accomplish something similar with FirstSortedValue, although I think it may perform a little slower.

Patric_Nordstrom
Employee
Employee

Thank you all for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea by commenting and liking.

Thanks, 

Patric

Status changed to: Open - Collecting Feedback