topic Re: Help with straight table/Rank function in QlikView

Help with straight table/Rank function

qlikuser222 — Sat, 16 Nov 2024 21:15:35 GMT

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 — Tue, 12 Mar 2019 15:58:43 GMT

Use expression like below

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

with current data first 2 rows will have @

qlikuser222 — Tue, 12 Mar 2019 17:02:52 GMT

Thanks for the Reply,

how can i show @ only on he first row?

Thanks

dplr-rn — Tue, 12 Mar 2019 17:08:31 GMT

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 — Tue, 12 Mar 2019 17:52:03 GMT

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 — Tue, 12 Mar 2019 17:55:05 GMT

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/ChartFunctions/RankingFunctions/rank.htm

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