Bottom function

Mon, 15 Nov 2010 21:23:18 GMT

Hi,

I have a chart that shows the top 10 customers using this dimension:

=If(aggr(rank(aggr(sum({<SYS_ID*={'BOOK_WIRE_1LINK', 'WIRE_DOMESTIC_1LINK', 'WIRE_INTERNATIONAL_1LINK', 'ADVANCE_1LINK', 'SK_1LINK'}>} TXN_COUNT), CUST_NO), 4, 2), CUST_NAME) <= 10, CUST_NAME)

I'd also like to show the bottom 10 customers. I think I need to use the bottom function but this is not getting me what I need:

=If(aggr(bottom(aggr(sum({<SYS_ID*={'BOOK_WIRE_1LINK', 'WIRE_DOMESTIC_1LINK', 'WIRE_INTERNATIONAL_1LINK', 'ADVANCE_1LINK', 'SK_1LINK'}>} TXN_COUNT), CUST_NO), 4, 2), CUST_NAME) <= 10, CUST_NAME)

I need help with the syntax. Any help would be greatly appreciated.

Thanks,

Shannon

Bottom function

johnw — Mon, 15 Nov 2010 21:46:33 GMT

You can get the bottom 10 customers with rank by just reversing the sign. So I suspect something along these lines would work:

if(aggr(rank( sum(...)),CUST_NAME)<=10
or aggr(rank(-sum(...)),CUST_NAME)<=10,CUST_NAME)

topic Bottom function in QlikView

Bottom function

Bottom function