idea Re: Minstring and Maxstring should accept rank as 2nd parameter(like min/max) - Status changed to: Closed - Archived in Suggest an Idea

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

simonaubert — Tue, 02 Feb 2021 11:38:37 GMT

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 )

So I would like the min/max string functions to work exactly like min /max. It seems easy and add consistence.

Best regards,

Simon

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

msteedle — Mon, 22 Mar 2021 10:44:55 GMT

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

Re: Minstring and Maxstring should accept rank as 2nd parameter(like min/max) - Status changed to: Open - Collecting Feedback

Patric_Nordstrom — Thu, 13 Jan 2022 11:27:33 GMT

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

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 15:45:30 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Minstring and Maxstring should accept rank as 2nd parameter(like min/max) - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:45:31 GMT