Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Count If value of calculated measure is X

I have a calculated measure and would like to know how to get a count of ClientIDs that have a value greater than X after performing the calculated Measure

Calculated Measure formula that gives me a percentage number:

(Sum([Billable Case Hours])+Sum([Non Billable Case Hours])+Sum([Non Billable Case Hours(ASP)]))/(sum(Total Revenue)/500)

Would like to count the number of ClientIDs that are over 100% or 1.0 in the above measure formula.

This attempt is not working:

if(Sum([Billable Case Hours])+Sum([Non Billable Case Hours])+Sum([Non Billable Case Hours(ASP)])/(sum(Total)/500)>1,count([Client ID]))

3 Replies
tamilarasu
Champion
Champion

Hi David,

Sum(Aggr( If(Sum([Billable Case Hours])+Sum([Non Billable Case Hours])+Sum([Non Billable Case Hours(ASP)])/(sum(Total)/500)>1,1), [Client ID]))


Or


Count(Aggr( If(Sum([Billable Case Hours])+Sum([Non Billable Case Hours])+Sum([Non Billable Case Hours(ASP)])/(sum(Total)/500)>1,[Client ID]), [Client ID]))

Anonymous
Not applicable
Author

Tamil, Thank you very much!

tamilarasu
Champion
Champion

Not a problem David. Have a nice day