Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Highlighting first highest 3 under each Branch

Dear Friends!

If I'am to show first highest three MEs under each depts, how the equation be revised to accommodate said changes.Appreciate if I am provided with a solution!

 

Regards

 

Neville

 

4 Replies
Highlighted

Re: Highlighting first highest 3 under each Branch

May be this

Sum(Aggr(
  IF(Sum(REFUND%) >= Max(TOTAL<BRANCH> Aggr(Sum(REFUND%), ME, BRANCH, REGION), 3), Sum(REFUND%))
, ME, BRANCH, REGION))
Highlighted
Specialist
Specialist

Re: Highlighting first highest 3 under each Branch

Hi Sunny,

Once your formula applied three employees are chosen but not in a descending order such as 1st one being the highest refund ratio holder & second being the 2nd highest  etc. Please refer the green coloured column where expected order is not maintained. Should the expression to be amended ?

Thanks

 

 

 

 

 

Highlighted

Re: Highlighting first highest 3 under each Branch

I am not sure I follow your question. Can you explain what is the issue?

Highlighted
Specialist
Specialist

Re: Highlighting first highest 3 under each Branch

I need to arrange the highest three people under each Branch such as below. The formula doesn't fix this order, isn't it?

BRANCHMEREGIONSUM(REFUND%)
EHELIYAGODADAYANSABA75%
EHELIYAGODANIMESHSABA45%
EHELIYAGODADILIPSABA40%
    
EHELIYAGODATotal 165%
EMBILIPITIYAKUMARSOU60%
EMBILIPITIYADINESHSOU50%
EMBILIPITIYASILVASOU15%
    
    
EMBILIPITIYATotal 145%
RATNAPURANIMALSABA29%
RATNAPURAHIMANSABA25%
RATNAPURAPIYALSABA15%