Skip to main content
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

Nested Aggregation and CountIf together

Hello,

I have written a set expression which calculates a measure for me.

calculation:

=(Sum(A)+(sum({<Account_Id={'4'}>}A)))/(sum({<Account_Id={'2'}>}A))        

I need to check and count values of this measure that are greater than 0.95

How can I achive this ?

Thanks,

Sailee

0 Replies