Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Partner
Partner

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
Highlighted

Re: Linear Table: Sum

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

Highlighted
MVP
MVP

Re: Linear Table: Sum

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

Use a straight table and an expression like

=sum(QuantityField)

Highlighted

Re: Linear Table: Sum

please provide sample data/application to demonstrate.

thanks

regards

Marco