topic Re: Ranking aggregate values in text object in QlikView

Ranking aggregate values in text object

Tue, 01 Sep 2015 10:44:45 GMT

Hi,

I have an aggregate function that gives the following results:

My aggregate function is as follows:

aggr(sum(Sale),Customer,Product)

However, I want to put the customer-product combination into a text object, along with where the combination ranks in terms of sale. Example:

If my filter is customer Y, Product C, I want to see the Rank as follows:

Customer-Product Rank

Y-C 1

If my filter is Customer Y, Product D, I want to see the Rank as follows:

Customer-Product Rank

Y-D 2

Meaning I just want to display the rank in a text object. How can I achieve this? Thanks.

Kushal_Chawda — Tue, 01 Sep 2015 10:54:18 GMT

Please see the attached

sunny_talwar — Tue, 01 Sep 2015 10:54:30 GMT

Try this expression:

=If(GetSelectedCount(Product) = 1 and GetSelectedCount(Customer) = 1,

Aggr(If(Sum(Sale)> 0,Rank(TOTAL sum({<Product =, Customer =>}Sale))), Product, Customer))

Tue, 01 Sep 2015 10:56:21 GMT

Hi,

I realised you did the ranking via the Script. Is it possible to do it entire in the set analysis instead, rather than a script? Thanks.

Tue, 01 Sep 2015 11:02:14 GMT

This works well. Apparently I needed to add in the total keyword in my rank function.