Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
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
Partner

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
Partner

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
Partner

hi 

glad i could help 

merry Christmas