Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mmarchese
Creator II
Creator II

Apply set analysis to whole expression instead of each function?

This works:

Sum({<ID={8}>} m_count1) + Sum({<ID={8}>} m_count2) + Sum({<ID={8}>} m_count3)

But it involves specifying the same set expression repeatedly.  Is there a way to apply set analysis to the expression as a whole?  I'm looking for something like this:


{<ID={8}>} Sum(m_count1) + Sum(m_count2) + Sum(m_count3)


Note: I know that in this particular case, I could do this:

Sum({<ID={8}>} m_count1 + m_count2 + m_count3)

But sometimes you can't get away with doing the math pre-aggregation.

1 Reply
sunny_talwar

Not advisable, but may be this

Sum({<ID = {8}>} Aggr(Sum(m_count1) + Sum(m_count2) + Sum(m_count3), YourChartDimensions))

This would be unnecessarily complicating your expression