Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using "Total Mode" in Expression Tab

In the Total Mode when I click on Sum of rows or Average of rows, it seems to include the total row as well.

GoodCount
80.3%0.8029382
77.4%0.7735849
31.4%0.3140831
98.2%0.9822695
41.5%0.4150943
99.8%0.9978118
100.0%1
100.0%1
0.0%
69.8%9
78.6%8


How do I exclude the total row?

Thanks

Brian in Chicago

1 Reply
pover
Partner - Master
Partner - Master

Brian,

Your total row is the row that says 0.0%? Are you importing a total row from Excel? I guess I don't understand completely why you have total row and then a sum or average of rows?

Regards.