Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
mmarchese
Not applicable

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 applicable

Re: Apply set analysis to whole expression instead of each function?

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