Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Read about the latest Qlik Community enhancements on the Community News blog!
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum of top 5 performers in a text box

Hi Experts, would really appreciate help with a problem.

I have a Straight Table that shows me the top 5 clients based on their total score (IM_SCORE). However, what I am trying to accomplish, is have the top 5 total sum in a textbox, as that number will be used for further analysis. Below is the expression used to calculate the total score, with the client as the dimension:

=sum(if(IM_YEAR=Config_IM_Year, IM_SCORE, 0))

I have tried to play around with the rank formula, but no success.

I'm new to this and any suggestions would be greatly appreciated!

0 Replies