Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Aggregation Qliksense

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

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi @JoseGarcia 

Try this expression

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

Thanks and Regards
Mayur Ingale

View solution in original post

5 Replies
Highlighted
Partner
Partner

Hi @JoseGarcia 

Try this expression

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

Thanks and Regards
Mayur Ingale

View solution in original post

Highlighted
Contributor III
Contributor III

Excellent! It did work!

Thank you very much!
Contributor III
Contributor III

Brilliant! It worked!

Thanks a million!

Highlighted
Contributor III
Contributor III

Try this as well,

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

Highlighted
Contributor III
Contributor III

Hi there, 

your expression also worked!

Thanks a million! 🙂