Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Community Browser