Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Brysonds
Contributor III
Contributor III

Aggregation with Below() not working as expected

Hello, I have a simple table that works as expected. It contains the following fields.

Year/Period

Sum(Price) 

Below(Sum(Price) 

Variance (between the two prior measures)

Change ( an if/then expression to show if the measure value increased from the prior month)

Brysonds_0-1666721877387.png

 

 

The problem I have is that when I add more dimensions (like Company and Customer), Below(Sum(Measure)) no longer works.

I tried using an aggr function to make this work, but haven't been successful. 

Sum(Aggr(Below(Price), Company, Customer, Year/Period)) returns values but not the correct ones

Below(Sum(Aggr(Price, Company, Customer, Year/Period))) returns nothing

 

Brysonds_1-1666722304192.png

 

Can anyone help with the correct approach?

Labels (3)
0 Replies