Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
fmazzarelli
Partner - Creator III
Partner - Creator III

Linear Table: Sum

safac1.png

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?

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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
MVP
MVP

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

Use a straight table and an expression like

=sum(QuantityField)

MarcoWedel

please provide sample data/application to demonstrate.

thanks

regards

Marco