Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
qlikuser222
Contributor

Help with straight table/Rank function

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

1 Solution

Accepted Solutions
Partner
Partner

Re: Help with straight table/Rank function

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,'@')
5 Replies
Partner
Partner

Re: Help with straight table/Rank function

Use expression like below

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

with current data first 2 rows will have @

qlikuser222
Contributor

Re: Help with straight table/Rank function

Thanks for the Reply,

 

how can i show @ only on he first row?

 

Thanks

Partner
Partner

Re: Help with straight table/Rank function

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
Contributor

Re: Help with straight table/Rank function

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

Partner
Partner

Re: Help with straight table/Rank function

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.