Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
limfungkeat
Contributor III
Contributor III

Ranking in pivot table - to rank base on best price offer

Hi Gurus out there , read about the Rank() functions and also lots of example . However , those are like Rank on the highest value ..how to display something like the below in a pivot table ? 

 

Untitled.jpg

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi 

if you want to rank according to the smallest value 

there is a simple trick (assuming all values are positive ) you can just use 

rank (-priceoffrer)

View solution in original post

3 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

if you want to rank according to the smallest value 

there is a simple trick (assuming all values are positive ) you can just use 

rank (-priceoffrer)

limfungkeat
Contributor III
Contributor III
Author

Thank you so much Lironbaram !  ...it will be my best Christmas present . 

lironbaram
Partner - Master III
Partner - Master III

hi 

glad i could help 

merry Christmas