topic Re: Question on Rank() in QlikView

Question on Rank()

mikecrengland — Mon, 26 Sep 2016 21:13:53 GMT

Hello All -

I'm trying to create a fairly simple bar chart that ranks sales by customer. The expression is a simple sum of sales and I want the rank on the Axis.

For the Axis, I'm using

rank(Aggr(sum({<CompanyGroup = >}BilledAmount),CompanyGroup))

The expression for the bar is

sum({<CompanyGroup *= >}BilledAmount)

Which works until a company is selected I have the color set up to grey-out the unselected:

But the rank goes to 1 when a company is selected and I actually want it to keep its actual rank. I thought the {<CompanyGroup = >} would accomplish it, but no luck.

Any thoughts?

Thanks!

mike

Re: Question on Rank()

sunny_talwar — Mon, 26 Sep 2016 21:17:08 GMT

How about this:

Aggr(Rank(Sum({<CompanyGroup = >} BilledAmount)) * Avg(1), CompanyGroup))

Re: Question on Rank()

mikecrengland — Mon, 26 Sep 2016 21:19:40 GMT

You are da man! Worked like a charm.

Re: Question on Rank()

vishsaggi — Mon, 26 Sep 2016 21:46:18 GMT

Hello Sunny,

Would you mind explaining this *Avg(1) what is this used for ??

Thanks,
V.

Re: Question on Rank()

sunny_talwar — Mon, 26 Sep 2016 21:47:34 GMT

Was not 100% sure if it was needed or not, but just to be safe I added it