Issues with "Top 10" List boxes

[#1]

Hello,

I am very much a newbie to QV, so please be gentle. I have what I think is a good first start at a KPI dashboard for our business users. One weird thing that is happening: I have two list boxes which I've built off of an Expression to select the top 10 Carriers and top 10 Clients for our company. See below:

Get Top 10 Carriers :

=aggr(if(rank(sum(GatewayEvents),4)<=10,CarrierName),CarrierName)

Get Top 10 Clients: 

=aggr(if(rank(sum(GatewayEvents),4)<=10,ClientName),ClientName)

The result is a nice horizontal list box that shows our users who the top 10 carriers and top 10 clients are by number of Gateway Events for the given time frame.

My problem is this: When I select one of the top 10 carriers, the top 10 client chart gets filtered as well - but only for 1 of the selected carrier's clients. Its absolutely bizzare. Same thing happens in reverse - if I select 1 client, only 1 carrier gets selected as well. I don't see why this happens when there is much more data available in both charts?

What I would like to happen this: if I select 1 of the top 10 carriers, then the top 10 clients are updated to reflect the top 10 for THAT carrier, and vice versa. It seems like this should happen by default, but perhaps I'm doing something wrong.

Any suggestions are very much appreciated!!

Thanks, Sarah

[Oleg_Troyansky]

Sarah,

it might be a long shot, but check your expressions in the list boxes. It sounds like you might have copied one expression into another and forgot to replace the field names in all places. Could that be the reason for the bizzaire behavior?

cheers,

Oleg

[#3]

Hi Oleg, thanks for your response but alas that is not the case. That was what I first thought I had done when I saw the strange behavior.

Perhaps I am not using the correct sort of approach? What I am trying to do is get the top 10 clients/carriers by a certain measure, in this case, Gateway Events. I want to display these in a list box so that the user can select from the top 10. There must be a "standard" way of implementing something like this?

Thanks, Sarah

[#4 · Accepted solution]

I am assuming your not using Qlikview 11, if you are use the dimension limits tab.  If not then you might need to encapsulate both dimensions in your aggrgation ?

[Oleg_Troyansky]

Sarah,

is there any way you could post an example app?

[advait_thakur]

Hi Sarah,

Can you post the documetn app please  ?

Thanks,
Advait

[#7]

Thanks Felim! Initially, I was just inserting the field as an expression into the sheet, which must've been the problem. I took your advice and inserted a new list box object on the Client/Carrier fields and with the expression of SUM(GatewayEvents). I then limited the Dimension to top 10 and hid the expression field. This works perfectly! Still not sure why the field as an expression didn't work, but this helps me out tremendously! Thank you again!

[#8]

Sorry Advait, I can not post the dashboard I am creating due to the fact that it contains propriatary information for our company. But I have already found my solution (see answer by Felim). Thanks all for your repsonses! Much obliged.