Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
limfungkeat
New 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
Honored Contributor II

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

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)

3 Replies
lironbaram
Honored Contributor II

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

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
New Contributor III

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

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

lironbaram
Honored Contributor II

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

hi 

glad i could help 

merry Christmas