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: 
Zagwit
Contributor
Contributor

Pivot Table - Sum If Aggr

I am trying to write an aggr expression but struggling with how to do it

Row: Paid Year

Column: Billed Year

Expression:

If the total Billed amount is greater than $50,000 for "company" than include the amount in the appropriate Paid Year/Billed year intersection of the pivot table.

Help?!

Zagwit 

 

Labels (2)
3 Replies
crusader_
Partner - Specialist
Partner - Specialist

Hi,

Hopefully I understood the requirement correctly. Try below expression

SUM(IF(aggr(sum(Amount),Company, BilledYear, PaidYear)>=55000,Amount))

 

1550171#M440196.PNG

 

 

 

 

 

 

 

 

 

//Andrei

VishalWaghole
Specialist II
Specialist II

No need to do aggregation.
You can simply use below expression,

=If(sum(Amont)>=50000,sum(Amont))

Hope this will work for you.

-Vishal Waghole
Zagwit
Contributor
Contributor
Author

This is exactly what I want. However I am just getting "0" at all the intersections that should have values.

Thoughts?

Z