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

Set Analysis

Please let me know, How to convert this expression using Set Analysis ?

=if(aggr(num(sum(opened)/sum(sent),'###'),pool_name)<0.05,sum(sent))

1 Reply
sunny_talwar

You can try this:

=Sum({<pool_name = {"=Aggr(Sum(opened)/Sum(sent), pool_name) < 0.05"}>} sent)