Aggregate Only Function in Bar Chart

[Chris49]

Hi all,

not sure if I put the question into the right category. I am quite new to QS  🙂

I am having problems to aggregate volume with partly redundant values for a bar chart.

Data

Contracts are not region specific. Contract C12 has a total volume of 200.

Goal

Dimension: Year

Measure: 

The measure needs to calculate the actual total volume of contracts. So I figured the basic would be:
= aggr( only (Volume), Contract)

However, Qliksense does not show anything in the chart. Any idea what I can do instead?

[GaryGiles · Accepted solution]

You need to wrap the aggr() function in the sum() function to use as a measure, like this:

=sum(aggr(Only(Volume), Contract))

[Chris49]

Thanks a lot! Still need to get more familiar with the syntax.