Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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