Using "Total Mode" in Expression Tab

Mon, 11 Oct 2010 21:47:19 GMT

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

Good	Count
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

Using "Total Mode" in Expression Tab

pover — Mon, 11 Oct 2010 22:04:37 GMT

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.

topic Using "Total Mode" in Expression Tab in QlikView

Using "Total Mode" in Expression Tab

Using "Total Mode" in Expression Tab