topic Re: Top Rank Chart Label in QlikView

Top Rank Chart Label

AC3 — Fri, 02 Oct 2015 15:38:08 GMT

I have a chart which plots the top ranking Customer over 2 days by hour.

The Expression used is: Sum({1<customer= {"=aggr(rank(sum(sales)), customer) = 1"}> } sales)

I'd like the Expression Label to be the customer with rank=1. I've tried this if(rank(sum(sales))=1,customer) but it's returning nulls.

Appreciate any help!

Gysbert_Wassenaar — Fri, 02 Oct 2015 15:41:12 GMT

Try =only({1<customer={"=rank(sum(sales))=1"}>} customer)

Fri, 02 Oct 2015 15:41:59 GMT

try below:

Sum({1<customer= {"$(=aggr(rank(sum(sales)), customer) = 1)"}> } sales)

mayankraoka — Fri, 02 Oct 2015 15:43:50 GMT

Did you try using firstsorted value function and aggr that and to display

it in descending order use - sign

AC3 — Fri, 02 Oct 2015 15:44:49 GMT

Awesome, thank you!!