Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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