aggregating a column

michaeldburt — Mon, 23 Mar 2015 19:41:39 GMT

Hello everyone-

I'm trying to create a text object that will aggregate a column in a table. The column is an expression that is creating totals for certain items. I want to only the show the total for ALL items in the text object. I've tried using the aggr function with little success.

I am trying to calculate the following:

((Standard * Actual) / Frozen) * Actual Cost

The calculation would be for each item (which has a specific value for each field), which is what I used in my aggr, but it wouldn't return any results. Any ideas?

Re: aggregating a column

Gysbert_Wassenaar — Tue, 24 Mar 2015 11:50:04 GMT

sum(((Standard * Actual) / Frozen) * [Actual Cost])

((sum(Standard * Actual)) / sum(Frozen)) * sum([Actual Cost])

sum((Standard * Actual) / Frozen)) * sum([Actual Cost])

((sum(Standard) * sum(Actual)) / sum(Frozen)) * sum([Actual Cost])

topic aggregating a column in QlikView

aggregating a column

Re: aggregating a column