topic Re: Get rank in textbox in QlikView

Get rank in textbox

woshua5550 — Wed, 25 Nov 2020 16:16:04 GMT

Hello experts

I need a expression in a textbox which will show current selected city's rank

plz have a look at the sample data below

when I select "Beijing" it should return "2" , when I select "Shanghai" it should return "1" ,"Chongqing" is "3"

I don't want to deal with it during data loading,plz give me the frontend solution

thanks

tresB — Thu, 19 Apr 2018 10:39:21 GMT

Try like:

=Aggr(rank(Sum({<City>}Amount)),City)

woshua5550 — Thu, 19 Apr 2018 11:02:05 GMT

Thanks Bro! It works

but how should I change this expression if I use alternate states on city filter ?

let's say I have city in a list box with Alternate States "G1" and textbox with default states

I tried "=Aggr(rank(Sum({G1<City>}Amount)),City)" but it doesn't work

plz help , thank you

pooja_prabhu_n — Thu, 19 Apr 2018 11:03:23 GMT

Try like this in text box

=aggr(rank(sum( {1<city=>} Amount)),city)

sunny_talwar — Thu, 19 Apr 2018 11:13:40 GMT

Try this may be

=Only({G1} Aggr(Rank(Sum({<City>} Amount)), City))

woshua5550 — Thu, 19 Apr 2018 11:18:36 GMT

Excellent ! Thank you Sunny!