Max Function when there are Identical Values

[Anonymous]

Hi All,

Have the below data:

ID

2

4

4

6

Max(ID) returns 6

Max(ID,2)  returns 4

Max(ID,3) returns 2 --> But i want it to return 4 since there are 2 4's. Anyway i can tweak the function to get this output?

Yours Truly,

S.Manikantan

[petter]

You might need the help of Rank() then:

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/ChartFunctions/RankingFunctions/ra...

[sunny_talwar · Accepted solution]

May be create another field in the script like this

LOAD ID,

     AutoNumber(RowNo(), ID) as SNo

FROM ...

and now try this

FirstSortedValue(ID, -(ID + SNo/1E10), 1) -> 6

FirstSortedValue(ID, -(ID + SNo/1E10), 2) -> 4

FirstSortedValue(ID, -(ID + SNo/1E10), 3) -> 4

FirstSortedValue(ID, -(ID + SNo/1E10), 4) -> 2

[Anonymous]

Thanks Sunny & Petter.

Sunny, i have been able to use your solution for my purpose. Thanks.

Yours Truly,

S.Manikantan.