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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis how do I divide two fields such as

Set Analysis how do I divide two fields such as (HRS/TOTAL_HRS)*100={">=75"}  want to see who has a rate of eqal to 75%

1 Reply
CELAMBARASAN
Partner - Champion
Partner - Champion

You cann't do it like that

Try with this

Count({<EmployeeID={"=(HRS / TOTAL_HRS)>=0.75"}>} EmployeeID)