Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
farolito20
Contributor III
Contributor III

Remove "Others" from the total when using limitation in a straight table

I am using a table to show the top 10 clients but in the Totals of the table I see the whole amount (including others), is it possible to get Totals of the top 10 only?

I am getting 91 instead of 85.

farolito20_0-1592614167589.png

This is the current configuration I have:

farolito20_1-1592614202400.png

 

 

Labels (3)
1 Solution

Accepted Solutions
fosuzuki
Partner - Specialist III
Partner - Specialist III

Go to the expression properties > Totals function > select Sum.

View solution in original post

2 Replies
fosuzuki
Partner - Specialist III
Partner - Specialist III

Go to the expression properties > Totals function > select Sum.

farolito20
Contributor III
Contributor III
Author

Thank you, it worked!