Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
You need to wrap the aggr() function in the sum() function to use as a measure, like this:
=sum(aggr(Only(Volume), Contract))
You need to wrap the aggr() function in the sum() function to use as a measure, like this:
=sum(aggr(Only(Volume), Contract))
Thanks a lot! Still need to get more familiar with the syntax.