
Creator
2019-03-12
10:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,222 Views
1 Solution
Accepted Solutions

Partner - Master III
2019-03-12
01:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,'@')
but if it s mandatory change the mode
If(Rank(TOTAL Sum(Amt
),4)=1,'@')
1,190 Views
5 Replies

Partner - Master III
2019-03-12
11:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use expression like below
If(Rank(TOTAL Sum(Amt
))=1,'@')
with current data first 2 rows will have @
1,203 Views

Creator
2019-03-12
01:02 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for the Reply,
how can i show @ only on he first row?
Thanks
1,194 Views

Partner - Master III
2019-03-12
01:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,'@')
but if it s mandatory change the mode
If(Rank(TOTAL Sum(Amt
),4)=1,'@')
1,191 Views

Creator
2019-03-12
01:52 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
1,185 Views

Partner - Master III
2019-03-12
01:55 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
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.
