Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Test if Sum of Revenue by Account is more than 10K

I create a new dimension in a pivot table. I would like a different behavior depending on whether the sum of revenues over Accounts is more or less than 10K. For now I came up with

If(AGGR(SUM(Revenue),[Account])>10000,'More','Less')

Which seems not to be working...

What is the correct syntax ?

Account is a dimension in the pivot table.

10 Replies
mahesh_agrawal
Creator
Creator

Can u share your application? Format of Aggr() depends on the no. of dimensions used.