Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
jworthulf
Creator
Creator

Summing columns using expressions in a straight table vs sum of rows

On the attached example I need some help formatting the expression for Route Fixed Cost.     When a routeID is selected the fixed cost column is populating correctly.    However if I do not use a route ID filter the cost field does not populate.

I want to take the Route Fixed Cost * # Routes and sum this using an expression vs sum of rows.

1 Solution

Accepted Solutions
Nicole-Smith

I think the aggr() in your expression might be the issue.

I tried this and I think it might work for you:
rangesum(count(distinct ship_dt)*RouteFixedCost)

View solution in original post

1 Reply
Nicole-Smith

I think the aggr() in your expression might be the issue.

I tried this and I think it might work for you:
rangesum(count(distinct ship_dt)*RouteFixedCost)