Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
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!