Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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