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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggr and sum if formula

I need to create a formula that will count the number of sales agents who have a presentation count within the presentation count bucket that I have created in the expression part of a straight table.   I have a criteria that the presentation must meet before I can count the agent in my sum.

I am creating a straight table with presentation count buckets at the top.

I am trying to get my formula to sum the count of agents who have 1 presentation a week where that sale premium is >= $600.

My problem is that my expression is counting all sales regardless of the premium amount.  So if the agent had 2 sales; Sale A had a premium of $200 and SaleB had a premium $1200 then the agent would be counted in the PresentationCount=1 bucket.

sum

(aggr(if(count([presentationcount])=1 and

sum({$<part1={'*life*'}>}part1.premiun)+

Sum({$<part2={'*single*'}>}part.2premium)+

Sum({$<part3={'*california*'}>}part3.premium) >= 600, 1, 0), [AgentName],Week))

Week12345+
4/25/201353211
4/18/201362121

Any help is greaty appreciated.  Thanks!

0 Replies