Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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!