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

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

limfungkeat — Mon, 24 Dec 2018 06:17:51 GMT

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 ?

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

lironbaram — Mon, 24 Dec 2018 05:03:27 GMT

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)

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

limfungkeat — Mon, 24 Dec 2018 06:19:32 GMT

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

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

lironbaram — Mon, 24 Dec 2018 09:18:54 GMT

glad i could help

merry Christmas