topic rank in QlikView

rank

omid5ive — Thu, 16 Jun 2016 09:13:12 GMT

i want something like this:

rank(sum({<Branch_Code={1}>}sales))

what should i do?

Re: rank

MK_QSL — Thu, 16 Jun 2016 09:14:02 GMT

Your requirement is not clear... please provide some more information.

Re: rank

sunny_talwar — Thu, 16 Jun 2016 09:14:02 GMT

I don't see any issue with the expression you have above. Is it not working?

Re: rank

omid5ive — Thu, 16 Jun 2016 09:14:58 GMT

i need to set some condition on my ranking but i think in rank function i cant use set analysis

Re: rank

omid5ive — Thu, 16 Jun 2016 09:15:24 GMT

i want to see the rank of sale for each branch in some text box

Re: rank

sujeetsingh — Thu, 16 Jun 2016 09:15:29 GMT

You already have it . Just you need to load some data in your file and plot the chart with this expression.

Re: rank

sunny_talwar — Thu, 16 Jun 2016 09:15:54 GMT

Condition as in Set Analysis? Use that in the Sum function rather than Rank.

Re: rank

omid5ive — Thu, 16 Jun 2016 09:16:27 GMT

are you sure in rank function i can use set analysis?

because in my dashboard i cant use it
it will show nothing

Re: rank

sunny_talwar — Thu, 16 Jun 2016 09:17:41 GMT

For text box, you might need to do like this:

Only({<Branch_Code = {1}>} Aggr(Rank(Sum(Sales), Branch_Code))

Only({<Branch_Code = {2}>} Aggr(Rank(Sum(Sales), Branch_Code))

Only({<Branch_Code = {3}>} Aggr(Rank(Sum(Sales), Branch_Code))

....

and so on for each of your Branch Code

Re: rank

omid5ive — Thu, 16 Jun 2016 09:18:07 GMT

in my case it will show 1 every time

Re: rank

Kushal_Chawda — Thu, 16 Jun 2016 09:18:21 GMT

what set analysis condition you are trying to put?

Re: rank

omid5ive — Thu, 16 Jun 2016 09:19:57 GMT

it shows this

Re: rank

sunny_talwar — Thu, 16 Jun 2016 09:20:37 GMT

My bad, try this:

Only({<Branch_Code = {1}>} Aggr(Rank(Sum(Sales)), Branch_Code))

Only({<Branch_Code = {2}>} Aggr(Rank(Sum(Sales)), Branch_Code))

Only({<Branch_Code = {3}>} Aggr(Rank(Sum(Sales)), Branch_Code))

Re: rank

omid5ive — Thu, 16 Jun 2016 09:20:48 GMT

branch_code=1 or some other values

i want to have multi text box that contains the rank of each branch

Re: rank

omid5ive — Thu, 16 Jun 2016 09:24:32 GMT

Thank you Sunny