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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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