topic Rank Help again in QlikView

Rank Help again

Mon, 26 Nov 2012 11:02:30 GMT

Hi,

I am continuing to struggle with a rank expression! I would like to rank agents based on the calls they have received - this is the easy part. I only want to rank those that have received >0 calls and return that as a total (highest rank) in a column. My problem is that I can return the highest rank in a column but it is ranking the agents with 0 calls also which I want to avoid. In the attached example, I am looking to return on each row in the last column the value 14 which is the highest rank for those agents that had received >0 calls. I am currently getting 25 because it is ranking on the whole population which I want to avoid.

Thanks in advance

Haider

Re: Rank Help again

perumal_41 — Mon, 26 Nov 2012 11:20:31 GMT

Hi,

use this expression

max( Total aggr(rank(sum({<AGENT_ID={"=sum([EG_Agent_Talk_Time])<>0"}>}[EG_Agent_Talk_Time])),AGENT_ID))

Re: Rank Help again

swuehl — Mon, 26 Nov 2012 11:21:50 GMT

Just count the number of agents with TALKTIME > 0:

=count( TOTAL {<AGENT_ID = {"=sum([EG_Agent_Talk_Time])>0"}>} AGENT_ID)