topic Populate field based on rank expression in Qlik Learning Discussions

Populate field based on rank expression

Tue, 10 Feb 2015 18:23:09 GMT

I am looking to set the value of one field based on the output of a rank expression. For example, if I have total sales by sales person, and I rank those sales from highest to lowest, I want to populate a field (SalesLevel) based on that ranking. The top three would be "Gold Level", the next seven would be "Silver Level", the next 10 would be "Bronze Level"

Re: Populate field based on rank expression

maxgro — Tue, 10 Feb 2015 18:44:42 GMT

maybe, in a chart with salesperson as dim, this expression

if(rank(sum(Sales),4)<=3, 'Gold',

if(rank(sum(Sales),4)<=10, 'Silver',

if(rank(sum(Sales),4)<=20, 'Bronze',

'nothing'

)))

Re: Populate field based on rank expression

Tue, 10 Feb 2015 18:52:23 GMT

That gives me what I was looking for. Thank you for your quick response.