Aggregation Qliksense

[JoseGarcia]

Hi there, 

I am trying to add a sum of three different dimensions measures.

Basically A+B+C

I am using this formula: 

Sum(Aggr(sum([Bombardier CET not Done]), sum([Avanti CET not done]), sum ([TPE CET not Done])

))

But no joy! 😞
Can anyone assist?

Thanks all!

Jose

[mayuringale25 · Accepted solution]

Hi @JoseGarcia 

Try this expression

sum([Bombardier CET not Done]) + sum([Avanti CET not done]) + sum([TPE CET not Done])

[JoseGarcia]

Excellent! It did work!

Thank you very much!

[JoseGarcia]

Brilliant! It worked!

Thanks a million!

[IamAlbinAntony]

Try this as well,

RangeSum(sum([Bombardier CET not Done]), sum([Avanti CET not done]), sum ([TPE CET not Done]))

[JoseGarcia]

Hi there, 

your expression also worked!

Thanks a million! 🙂