Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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