Help with straight table/Rank function

[qlikuser222]

Hi All,

I have a requirement whee i need to show a special character only on the top row of the table where amount is maximum. 

Can anyone please help me to understand how to solve it?

PFA which has detailed description.

Thanks

[dplr-rn]

Use expression like below

If(Rank(TOTAL Sum(Amt
))=1,'@')

with current data first 2 rows will have @

[qlikuser222]

Thanks for the Reply,

how can i show @ only on he first row?

Thanks

[dplr-rn · Accepted solution]

if both values are the same why would you want only 1 to be shown as top?
but if it s mandatory change the mode
If(Rank(TOTAL Sum(Amt
),4)=1,'@')

[qlikuser222]

Thanks

Can i please know why did you put 4? what does it do? do we need to change 4 to something else when we have million records in table?

Thanks

[dplr-rn]

No you dont need to change.
it is mode argument in rank function
https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunctio...

Mode 4, basically return 1,2,3,4... even if 1 and 2 values are the same.
check the link for what more details.