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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Heny
Contributor III
Contributor III

count distinct user with above 100% efficiency

I have this expression  Sum(norm*total_pages_count)/sum(total_time) that give me efficiency percentage

now I would like to count users on a monthly scale that are above 100%

I've tried 

count({<user={"=Sum(norm*total_pages_count)/sum(total_time)>0.1"}>} distinct user)

but I guess I'm totally off with my expression

any help?

Labels (2)
11 Replies
Kushal_Chawda

@Heny  please mark appropriate reply as solution

Heny
Contributor III
Contributor III
Author

I have a problem with my browser, it marks my solution as accepted

trying to change it