topic Re: Linear Table: Sum in QlikView

Linear Table: Sum

fmazzarelli — Thu, 04 Jun 2015 09:35:41 GMT

I import a 'xls file' into a linear table and I need to sum Quantity field.

Click right button, property but there is no present sum function.

Howto?

alexandros17 — Thu, 04 Jun 2015 09:38:29 GMT

I think you mean Straight Table (The one in Chart)

Add a new expression and write Sum(myField)

Table objects do not allow any expression

Let me know

swuehl — Thu, 04 Jun 2015 09:39:00 GMT

Seems like you are using a table box, which does not allow aggregations.

Use a straight table and an expression like

=sum(QuantityField)

MarcoWedel — Sun, 28 Jun 2015 00:08:59 GMT

please provide sample data/application to demonstrate.

thanks

regards

Marco