topic Re: Set Analysis how do I divide two fields such as in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-how-do-I-divide-two-fields-such-as/m-p/388210#M144874 <HTML><HEAD></HEAD><BODY><P>You cann't do it like that</P><P>Try with this</P><P>Count({&lt;EmployeeID={"=(HRS / TOTAL_HRS)&gt;=0.75"}&gt;} EmployeeID)</P></BODY></HTML> Mon, 20 May 2013 22:14:02 GMT CELAMBARASAN 2013-05-20T22:14:02Z Set Analysis how do I divide two fields such as https://community.qlik.com/t5/QlikView/Set-Analysis-how-do-I-divide-two-fields-such-as/m-p/388209#M144873 <HTML><HEAD></HEAD><BODY><P>Set Analysis how do I divide two fields such as (HRS/TOTAL_HRS)*100={"&gt;=75"}&nbsp; want to see who has a rate of eqal to 75%</P></BODY></HTML> Mon, 20 May 2013 19:48:57 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-how-do-I-divide-two-fields-such-as/m-p/388209#M144873 2013-05-20T19:48:57Z Re: Set Analysis how do I divide two fields such as https://community.qlik.com/t5/QlikView/Set-Analysis-how-do-I-divide-two-fields-such-as/m-p/388210#M144874 <HTML><HEAD></HEAD><BODY><P>You cann't do it like that</P><P>Try with this</P><P>Count({&lt;EmployeeID={"=(HRS / TOTAL_HRS)&gt;=0.75"}&gt;} EmployeeID)</P></BODY></HTML> Mon, 20 May 2013 22:14:02 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-how-do-I-divide-two-fields-such-as/m-p/388210#M144874 CELAMBARASAN 2013-05-20T22:14:02Z